Well there's probably a slicker way to do this, but this does work. In the
first query combine the two item lists into one union. Then call the first
query with the second, grouping items and counting them, with only counts of
1 surviving ... then sending the results to Table1 (make-table).
Query1:
SELECT Table1.Item
FROM Table1
UNION ALL
Select Table2.Item
FROM Table2
Query2:
SELECT Query1.Item INTO [Table3]
FROM Query1
GROUP BY Query1.Item
HAVING Count(Query3.Item)=1
Bound to be someone out there with a more elegant solution, but you can use
this until it appears.
HTH
Anakin Moonwalker said:
Hi!
I have 2 tables:
TABLE1
apple
ball
dog
TABLE2
apple
ball
cat
dog
egg
How do I compare TABLE1 and TABLE2, then store the difference (in this case,
cat and egg) into TABLE3?
Thanks!