Finding unduplicate results

[Smigidy]

I need some programming help finding non-duplicate information in my tables.
Below is what I have in two different tables. If I try to find
non-duplicates for receipts I get 979.10, -961.57, and 602.32. If I try to
find non-duplicates for amount, I get 237.36, -961.57, and 602.32. How do I
get the last 4 rows of information as shown below?

TABLE A TABLE B
Receipt Amount Receipt Amount
A 17.53 A 17.53
B 979.10 B 979.10
C 979.10 C 979.10
D 979.10
E -961.57
F 602.32
A 237.36

 

[Douglas J. Steele]

SELECT TableB.Receipt, TableB.Amount
FROM TableB LEFT JOIN TableA
ON TableA.Receipt = TableB.Receipt
AND TableA.Amount = TableB.Amount
WHERE TableA.Receipt IS NULL

 

[Smigidy]

I'm getting a total amount of $1,237.93

SELECT TableB.Receipt, TableB.Amount
FROM TableB LEFT JOIN TableA
ON TableA.Receipt = TableB.Receipt
AND TableA.Amount = TableB.Amount
WHERE TableA.Receipt IS NULL

 

[Douglas J. Steele]

The query works for me: I get 4 rows back:

Receipt Amount
D $979.10
E -$961.57
F $606.32
A $237.36

 

[Smigidy]

Got it, thanks!

The query works for me: I get 4 rows back:

Receipt Amount
D $979.10
E -$961.57
F $606.32
A $237.36