Default Bill to address in SQL report

[Former Member]

Hi Experts

i need to display the data of Customers, vendor & lead, based on 'Default Bill to Address'

Eg:-  if a BP is having more than 1 Bill to address and out of that one is Default, i need to get the data like

BP NAME          BP CODE                     BP ADDRESS (Default Address)

Pls suggest how to get it solved

Regards

[Former Member · Accepted solution]

Hi,

Hope this will help you,

select T0.Cardcode,T0.cardname,T1.Street  from ocrd T0

Inner join crd1 T1 ON T1.CardCode=T0.cardcode AND T1.Address=T0.BillToDef

Thanks,

Shan.