Uwe Oeder wrote:

> Don't know if this works in firebird
>
> SELECT * FROM Materials
>
> MINUS
>
> SELECT * FROM MaterialsCopy

AFAIK, It does not. You can always use something like this:

select * from Materials m
where not exists (
select * from MaterialsCopy mc
where m.PK = mc.PK
)

Where PK is the primary key of both tables.

HTH

--
Milan Babuskov
http://fbexport.sourceforge.net