I have created a UDF on the Service Call to identify the Billing and Shipping information for that specific Service Call. My intent is to create a Return Goods Authorization using that information.
The problem I am having is with the following query I get the addresses for the BP repeated for however many Service calls I have for that BP. Is there away to limit it to only showing the address once?
SELECT T2.[Address], T2.[Street], T2.[City], T2.[State] FROM OSCL T0 INNER JOIN OCRD T1 ON T0.customer = T1.CardCode LEFT OUTER JOIN CRD1 T2 ON T1.CardCode = T2.CardCode WHERE T2.[AdresType] ='S' AND
$[OSCL.CUSTOMER] = T1.[CardCode]
Thanks for your help