Code:
SELECT Table2.ID1, Table1.Text1, Max(Table3.ID3) AS MaxOfID3, First(Table3.Text3) AS FirstOfText3
FROM (Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID1) INNER JOIN Table3 ON Table2.ID3 = Table3.ID3
GROUP BY Table2.ID1, Table1.Text1;
change the joins to outer joins if you want rows where there is no ID3 as this
How do I display for each ID1 only its LAST occurrence? (In this case 1 - 478, 2 - 492, etc.)
isn't the same as
1 - Client Blue - 478 - Order April
2 - Client Green - 492 - Order April
3 - Client Red etc.
4 - Client Yellow etc.
since in since the last 2 rows don't have an ID3 value