Re: Call out for FULL JOIN - bug #18003

[ted strauss]

Just to clarify what is meant by FULL JOIN, here's an example from postgres.
Sometimes called FULL OUTER JOIN

=> SELECT * FROM t1 FULL JOIN t2 ON t1.num = t2.num;
num | name | num | value
-----+------+-----+-------
1 | a | 1 | xxx
2 | b | |
3 | c | 3 | yyy
| | 5 | zzz


reference: http://www.postgresql.org/docs/8.0/static/queries-table-expressions.html