Subject | Re: How to join unrelated tables? |
---|---|
Author | fabiano_bonin |
Post date | 2004-06-17T03:13:14Z |
> then, is it possible to construct a join to get:You can try this:
>
> 1,2,3,-,-,-
> 4,5,6,-,-,-
> -,-,-,a,b,c
> -,-,-,d,e,f
>
> where - means NULL?
select
*
from
table1
full outer join table2 on ( 1 <> 1 )