Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Mar 24, 1997

Simulating Multiple Outer Joins

Question:
I need to query a database with outer joins on more than one table, and am finding that my database doesn't support it. Is there any way to work around the problem?

Answer:
The best way is to use views. Create a view using the first outer join, and then select using the view and the second outer join. If you need to nest further, you can continue creating views for as many levels as necessary, though if the nesting is deep, your response time may be poor.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date