--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > 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

I don't mind the nulls, if some table has a colomn that the other
doesn't have it should list null for them.

Alexander