How to have query show differences between 2 tables?

Is there an easy way to have a query return only the differences between 2
tables?

something like...

SELECT * FROM tblA
UNION SELECT * FROM tblB
WHERE tblA.* <> tblB.*

????

thx.

re: How to have query show differences between 2 tables?

When creating a new query, select "Find Unmatched Query Wizard" from the
list. This will find all the records in the first table that are not in the
second table.

"deko" <dje422@hotmail.com> wrote in message
news:WF6Ob.2460$fB4.869@newssvr29.news.prodigy.com ...[color=blue]
> Is there an easy way to have a query return only the differences between 2
> tables?
>
> something like...
>
> SELECT * FROM tblA
> UNION SELECT * FROM tblB
> WHERE tblA.* <> tblB.*
>
> ????
>
> thx.
>
>[/color]

re: How to have query show differences between 2 tables?

> When creating a new query, select "Find Unmatched Query Wizard" from the[color=blue]
> list. This will find all the records in the first table that are not in[/color]
the[color=blue]
> second table.[/color]


excellent... thanks