Skip to Content
0
Former Member
Jun 21, 2010 at 06:13 PM

Ship to Address

17 Views

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