Matching records in linked tables

[DeZiner]

I have two tables. One has columns: Credit_Card, Amount, Date. The second has the same. I need to match the rows one by one. If it matches credit card number and amount mark it as done or delete it, either way. If it doesn't have a match mark it has such. But, if a row has a previous match I can not loop through it again it needs to be discarded from both tables or ignored. Any ideas of a query or a good starting point? DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic

 

[pigsie]

see my reply to your first post

 

[RedLion]

explain your table structure, and try to build a sql-statement, so we can help you to fix and make the right sql-statement

Charl