Hi
Is there a way to achieve a similar result as the this query with
firebird?

SELECT * FROM Materials EXCEPT SELECT * FROM MaterialsCopy

I did manage to get something similar with a join and a where statement
that compares every field but that is big and unsightly queries.
eg
select
table1
table2
left join table 1 on table2
where
t1.field1<>t2.field1 or
t1.field2<>t2.field2
etc.

Groete

Gerhardus Geldenhuis
Chief Technical Assistant
Reactor Theory(NECSA)
gerhardus@...
Mobile +27 83 784 7664
Office +27 12 305 5600