Re: What does the (+) mean?

On Mon, 9 Feb 2004, thief_NOSPAM_at_hotmail.com wrote:
> Sorry to ask a newbie-type question, but isn't a full outer
> join like:
>
> SELECT * FROM CLR, SEASON;
No, your query is a cartesian product.

TableA
1
2

TableB
2
3

Cartesian product of A and B brings back 1 2
1 3
2 2
2 3

Full outer join brings back

1 NULL
2 2
NULL 3

-- 
Galen Boyer