SELECT T0.[CardCode], T0.[CardName], T2.[Name], T2.[E_MailL], T0.[DocDate], T0.[DocNum], T1.[ItemCode], T1.[Dscription] FROM OINV T0 INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN OCPR T2 ON T0.CntctCode = T2.CntctCode INNER JOIN OCRD T3 ON T0.CardCode = T3.CardCode WHERE T3.[CardFName] = '[%0]' AND T1.[Dscription] LIKE '%[%2]%'
Hi gurus, this query works, however I'd like to show only the last invoice per customer. New to SAP and sql, but I believe this is where you use DISTINCT and TOP clauses? How do I apply it?