Don't know if this works in firebird

SELECT * FROM Materials

MINUS

SELECT * FROM MaterialsCopy

At 01:01 PM 11/13/2003 +0200, you wrote:

>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
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/