Multi table outer join - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Multi table outer join

Author

Topic

bmsgharr
Starting Member

5 Posts

Posted - 2006-04-28 : 04:22:30

I have been in the rather unusual situation where I have had to outer join a table (lets call it table1) with view1 and outer join the table with view2. Both views contain outer joins!!!

My questions is:
How do you go about joining table1 with view1 and view2 using the ANSI SQL outer join syntax?

TIA

Graham Harris

Data dictionary:

table1:

CLIENT_REF INT
CLIENT_NAME

view1:

CLIENT_REF INT
FIELD_1 VARCHAR(255)

view2:

CLIENT_REF INT
SOME_OTHER_FIELD VARCHAR(255)

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-04-28 : 04:32:13

In SQL Server help file, read about inner joins

Also Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

Madhivanan

Failing to plan is Planning to fail

bmsgharr
Starting Member

5 Posts

Posted - 2006-04-28 : 04:35:40

The trouble is I learnt SQL on Oracle 7, 8i so left outer/inner etc is alien to me, anyway thanks for the links.

Graham Harris

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources