--- In firebird-support@yahoogroups.com, "Arno Brinkman"
...

>
> You can do that with UNION ALL :
>
> SELECT
> SomeName AS Field1,
> SomeOtherStuff AS Field2
> FROM
> Table1
> UNION ALL
> SELECT
> OtherName,
> SomeOtherStuff
> FROM
> Table2

Thanks, looks like what i need, but what if i also need to get a field
that is in only 1 table?
I get the following error: -count of column list and variable list do
not match

How can i do this?

TiA

>

...