I want to get vaendTable from logisticsElectronicAddress. I dont know what are the relations between them. Can you please help me.?
With the help of location in logisticsElectronicAddress find the related party in DIrPartyLocation.
From the party you should be able to find the Vendor (VendTable.Party)
sir I need query.
Thanks in advance.
select firstonly vendTable
exists join dirPatyLocation
where dirPartyLocation.Party == vendTable.Party
&& dirPartyLocation.Location == logisticsElectronicAddress .Location