Monday, February 9, 2015

SQL query to extract primary address from CUSTTABLE

The following query can be used to extract the primary address from the CUSTTABLE table:

 select CUSTTABLE.ACCOUNTNUM, DIRPARTYTABLE.NAME, Address.ADDRESS  
 from CUSTTABLE  
 left outer join DIRPARTYTABLE ON DIRPARTYTABLE.RECID = CUSTTABLE.PARTY  
 left outer join LOGISTICSLOCATION ON LOGISTICSLOCATION.RECID = DIRPARTYTABLE.PRIMARYADDRESSLOCATION  
 left outer join LOGISTICSPOSTALADDRESS AS Address ON Address.LOCATION = LOGISTICSLOCATION.RECID  
 Order by CUSTTABLE.ACCOUNTNUM
Posted by at
Labels: ,

1 comment:

  1. UnknownDecember 2, 2015 at 9:59 PM

    Hi,
    The logisticpostaladdress table could have more than One record linked to the same location field? If yes, how could be managed? Otherwise, if i would join my custable with logisticpostaladdress i'd duplicate my dimension.

    Thanks in advance

    ReplyDelete

Subscribe to: Post Comments (Atom)