Hey guys,
Suppose I have two tables with the same schema, and using one field of each, can I easily get the difference from both tables with a single query?

Something like
Code:
'Table A
ID  qty
e4 1
e5 20
e6 2
e7 5

'Table B
ID  qty
e4 1
e5 22
e3 12

'Producing
ID  qtyfromA   qtyfromb
e3    0                12
e5    20               22
e6    2                 0
e7    0                 5
Where it joins the tables, but only tells me what's different, and what's entirely missing from both sides of the join? I'm not too hot with SQL. I can make it pull the differences where both tables have the same ID number with different qty numbers, but not where either table is missing both..

Bill