A join with no join condition in the WHERE clause produces what you want
i.e the Cartesian
product of the two tables.
> -----Original Message-----
> From: krachyn_at_cadvision.com (Ken Rachynski)
> [SMTP:krachyn_at_cadvision.com]
> Posted At: Monday, August 09, 1999 10:22 PM
> Posted To: misc
> Conversation: Full Outer Joins possible?
> Subject: Full Outer Joins possible?
>
> Good day,
>
> I'm trying to figure out if the following is possible. I can do it
> with other servers.
>
> I am trying to join two tables such that I get all of the records in
> table A that have matching data in table B, plus all of the records in
> Table A without matching data in table B, plus all of the records in
> table B without matching data in Table A. Can this be done?
>
> IE
> Table A
> id data_a
> 1 1
> 2 2
> 5 3
>
> Table B
> id data_b
> 2 1
> 3 2
> 4 3
> 5 4
>
> Result
> id data_a data_b
> 1 1 NULL
> 2 2 1
> 3 NULL 2
> 4 NULL 3
> 5 3 4
>
Received on Tue Aug 10 1999 - 05:28:47 CDT
