Before Oracle 10g, the only way to perform a full outer join was to use two queries -- one that does a right outer...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
join and the other that does a left outer join. And then use the UNION or UNION ALL operator between the two result sets to combine them into a full outer join.
Oracle 10g introduced the the ANSI-compliant FULL OUTER JOIN clause which makes the above unnecessary.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.