At 09:07 AM 6/14/2004, kimon_the_athenian2 wrote:

>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

That is a UNION. Check any SQL text for the syntax.

Regards,


Ann