> You can do that with UNION ALL :
>
> SELECT
> SomeName AS Field1,
> SomeOtherStuff AS Field2
> FROM
> Table1
> UNION ALL
> SELECT
> OtherName,
> SomeOtherStuff
> FROM
> Table2
>
> NOTE! If both fields from table1 and table2 have a different
> datatype/length
> then you must cast 1 of them to the same datatype/length as the other one.
>
> Regards,
> Arno Brinkman
> ABVisie

Won't that give him all the nulls as well?
Alan