INNER JOIN + TOP 1?

[omata]

Vielleicht so...

SQL-Code:

SELECT * 
FROM Shopping s
INNER JOIN Shoppinganzahl a
  ON s.ID = a.ParentID
WHERE datum = (SELECT MAX(datum)
               FROM Shoppinganzahl
               WHERE ParentID = a.ParentID)

Gruss
Thorsten