Default Bill to address in SQL report
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
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