SQL to list Supplier Addresses

Supplier details are held in two tables. These tables are SUPPLIER and CORPORATE_ADDRESS. Not surprisingly the address details are held in the CORPORATE_ADDRESS table. The two tables can be joined on the SUPPLIER_ID attribute which is common to both e.g.

select SUPPLIER.SUPPLIER_CODE, SUPPLIER.SUPPLIER_NAME,
CORPORATE_ADDRESS.ADDRESS_LINE_1,
CORPORATE_ADDRESS.ADDRESS_LINE_2,
CORPORATE_ADDRESS.ADDRESS_LINE_3,
CORPORATE_ADDRESS.ADDRESS_LINE_4,
CORPORATE_ADDRESS.ADDRESS_LINE_5,
CORPORATE_ADDRESS.POSTCODE
from SUPPLIER, CORPORATE_ADDRESS
where CORPORATE_ADDRESS.SUPPLIER_ID = SUPPLIER.SUPPLIER_ID
and DEFAULT_ADDRESS ="T"

This will list out the default addresses for all suppliers. Of course a supplier may have multiple address so the DEFAULT_ADDRESS may not be required. The details of all the attributes in the two tables can be seen by using the database analyser

Interloan supplier details are held in ILL_SUPPLIER and ILL_SUPPLIER_ADDRESS.

Thanks

Brian Crampton
Developer, Talis