Need some help with SQL

[former_member370721]

Hi

I have

SELECT T1.[U_NF_LagPlatz1] AS 'Lagerplatz 1', T1.[U_NF_LagPlatz2] AS 'Lagerplatz 2', T0.[ItemCode] AS 'Artikelnr.', T0.[ItemName] AS 'Artikelbeschreibung', T0.[FrgnName] AS 'Zusatzbeschreibung', T0.[OnHand] AS 'Bestand Gesamt'  
FROM  [dbo].[OITM] T0  INNER  JOIN [dbo].[OITW] T1  ON  T1.[ItemCode] = T0.[ItemCode]  INNER JOIN [dbo].[ITT1] T2 ON T0.[ItemCode] = T2.[Code]
WHERE T1.[WhsCode] = 'NFE-1'  AND (T0.[ItemCode] LIKE '%KAA%' OR T2.[Father] LIKE '%KAA%')
ORDER BY T1.[U_NF_LagPlatz1], T0.[ItemCode]

and it basically retruns exactly what I want.

However, some items are listed multiple times. How do I get every item to be listed only once?

Thanks

Franz

[Former Member · Accepted solution]

Hi Franz,

Try:

SELECT Distinct T1.[U_NF_LagPlatz1] AS 'Lagerplatz 1', T1.[U_NF_LagPlatz2] AS 'Lagerplatz 2', T0.[ItemCode] AS 'Artikelnr.', T0.[ItemName] AS 'Artikelbeschreibung', T0.[FrgnName] AS 'Zusatzbeschreibung', T0.[OnHand] AS 'Bestand Gesamt'  
FROM  [dbo].[OITM] T0  INNER  JOIN [dbo].[OITW] T1  ON  T1.[ItemCode] = T0.[ItemCode]  INNER JOIN [dbo].[ITT1] T2 ON T0.[ItemCode] = T2.[Code]
WHERE T1.[WhsCode] = 'NFE-1'  AND (T0.[ItemCode] LIKE '%KAA%' OR T2.[Father] LIKE '%KAA%')
ORDER BY T1.[U_NF_LagPlatz1], T0.[ItemCode]

Thanks,

Gordon

[former_member370721 · Accepted solution]

Only a DISTINCT ... Great, Thanks!

SQL is just too far away from C I am used to.