Supplier addresses

Brian Crampton — Tue, 17 Oct 2006 09:13:10 +0100

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

SQL to list Supplier Addresses

Eoin Mc — Mon, 16 Oct 2006 16:57:37 +0100

Does someone have an SQL query to produce a list of supplier names & full addresses. Any help provided would be much appreciated.
Thanks,
Eoin

Talis Developer Network - SQL to list Supplier Addresses - Comments

Supplier addresses

SQL to list Supplier Addresses