I am trying to select specific columns from multiple tables based on a
common identifier found in each table.
For example, the three tables:
PUBACC_AC
PUBACC_AM
PUBACC_AN
each have a common column:
PUBACC_AC.unique_system_identifier
PUBACC_AM.unique_system_identifier
PUBACC_AN.unique_system_identifier
What I am trying to select, for example:
PUBACC_AC.name
PUBACC_AM.phone_number
PUBACC_AN.zip
where the TABLE.unique_system_identifier is common.
For example:
----------------------------------------------
PUBACC_AC
=========
unique_system_identifier name
1234 JONES
----------------------------------------------
PUBACC_AM
=========
unique_system_identifier phone_number
1234 555-1212
----------------------------------------------
PUBACC_AN
=========
unique_system_identifier zip
1234 90210
When I run my query, I would like to see the following returned as one
blob, rather than the separate tables:
-------------------------------------------------------------------
unique_system_identifier name phone_number zip
1234 JONES 555-1212 90210
-------------------------------------------------------------------
I think this is an OUTER JOIN? I see examples on the net using a plus
sign, with mention of Oracle. I'm not running Oracle...I am using
Microsoft SQL Server 2000.
Help, please?
P. S. Will this work with several tables? I actually have about 15
tables in this mess, but I tried to keep it simple (!??!) for the above
example.
Thanks in advance for your help!
NOTE: TO REPLY VIA E-MAIL, PLEASE REMOVE THE "DELETE_THIS" FROM MY E-MAIL
ADDRESS.
Who actually BUYS the cr@p that the spammers advertise, anyhow???!!!
(Rhetorical question only.)