Hi!

If table1 data is:

1,2,3
4,5,6

and table2 data is

a,b,c
d,e,f

then, is it possible to construct a join to get:

1,2,3,-,-,-
4,5,6,-,-,-
-,-,-,a,b,c
-,-,-,d,e,f

where - means NULL?


I'm sorry if this question isn't Firebird specific but I didn't know
a better place to ask.

Aivar