Simulating Multiple Outer Joins

Question:
I need to query a database with outer joins on more thanone 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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: