> Hi
> Is there a way to achieve a similar result as the this query with
> firebird?
>
> SELECT * FROM Materials EXCEPT SELECT * FROM MaterialsCopy
>

SELECT * FROM Materials WHERE MATERIALS_ID NOT IN SELECT MATERIALS_ID FROM
MaterialsCopy

Alan