Skip to Content
Jul 03, 2014 at 04:35 AM

Special Prices for Customer with Base Price amount


Hi all

Please help to correct my Query below. It shouldn't shows so many duplicated results with different Base Prices. You can simply run this in any Demo Database.

SELECT T0.[ItemCode],T1.[ItemName], T4.[ItmsGrpNam], T0.[CardCode], T2.[CardName], T5.[GroupName],T3.[SlpName],T0.[Price], T0.[Currency], T0.[Discount], T0.[ListNum], T0.[AutoUpdt], T0.[EXPAND], T6.Price FROM OSPP T0 INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN OSLP T3 ON T2.SlpCode = T3.SlpCode INNER JOIN OITB T4 ON T1.ItmsGrpCod = T4.ItmsGrpCod INNER JOIN OCRG T5 ON T2.GroupCode = T5.GroupCode inner join ITM1 T6 on T0.[ListNum] = T6.PriceList inner join OPLN T7 on T6.PriceList=T7.ListNum