3 ms·
What is a full join? I've been working with Oracle for 10 years and I've never used that term. I know what a left join is and an outer join, but not a full join
by fendale 14y ago
What is a full join? I've been working with Oracle for 10 years and I've never used that term. I know what a left join is and an outer join, but not a full join.
- McGlockenshire 14y ago"Conceptually, a full outer join combines the effect of applying both left and right outer joins. Where records in the FULL OUTER JOINed tables do not match, the result set will have NULL values for every column of the table that lacks a matching row." http://en.wikipedia.org/wiki/Join_(SQL)#Full_outer_join http://en.wikipedia.org/wiki/Join_(SQL)#Full_outer_join
- bricestacey 14y agoIt's an outer join.