match records from both table then delete

[din2005]

Hi all i have 2 tables,

i can make a query which displays records that match each other.

In table 1 there are 136 records in table 2 there are 5000. but in table 2 i would to delete the 136 records that match table 1.

any criteria do i need to put?

 

[citychap26]

Hi Din

Check out my thread

http://www.tek-tips.com/viewthread.cfm?qid=1059239&page=1

Cheers

SK

 

[PHV]

DELETE Table2.* FROM Table2 INNER JOIN Table1
ON your join condition here

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[citychap26]

Hi PHV,

I tried this approach and it did not work.

Cheers

SK

 

[JonFer]

What fields are you joining on? Are these fields indexed?

John

http://www.interautomateconsulting.com