deleting duplicate records using 2 tables

[Guest_imported]

DB= Access 97

Problem:
I have two tables, table_a and table_b.

table_a ->
contains 8700 non-duplicate records
table_b ->
contains 1700 non-duplicate records
table_b ->
contains 77 records that are also in table table_a

problem:
I want to match several columns in table_b to table_a and I want to say, if the row in table_a matches the row in table_b then delete that row from table_b

Solution: ????
can this be done in SQL? I am sure it can but my SQL is weak. I have tried several things, but with no luck.

thank you

 

[tlbroadbent]

Example 1:

Delete table_b.*
Where Exists
(Select * From table_a
Where col1=table_b.col1
And col2=table_b.col2
And col3=table_b.col3
ANd ...)

Example 2:

Delete b.*
From table_b b
Inner Join Table_a a
On b.col1=a.col1
And b.col2=a.col2
And b.col3=a.col3
And ... Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.