Hi All,
I was going through the "1146115A_SQL Reference to Data Manipulation Statements" and I got the idea about the outer join but as not able to get the meaning out of the last line ((((((The 1 enclosed in the brackets )))))). Can somebody explain Plz?
The outer join is meant to provide a method for regaining the "lost" information the inner join does not report. The outer join is an extended inner join that projects not only those rows that have commonality between the joined tables, but also those rows that have no counterpart in the other relation.
Depending on how you write an outer join, it can project the inner join rows plus any of the following: the nonmatching rows of the left table, the nonmatching rows of the right table, or the nonmatching rows from both.((((((( The attributes of the complementary row sets of an outer join are represented in the result set by nulls.))))))
Thanks.