Delete Query based on results in a seperate table

[kshope25]

I'm trying to delete all the rows in one table when the supplier code is equal to the supplier code in another table?

Can this easily be done?

 

[spikepl]

Make a select query in the query designer, a query that selects the rows that you wish to delete, based on joins and conditions between the two tables. Once you get that right, change the query from select to delete, and you should be good. Back you data up prior to all this, just in case.

 

[kshope25]

Thanks. I actually went into the SQL and got it to work finally, but it appears, looking at the design view, that the way you reccomended would have worked as well.