Delete Query

[pablofonto]

I need help!

I'm trying to delete records from Table1 where the field "Name" is equal to the field "Name" in Table2. Please see below what I tried and is not working, any ideas?

DELETE table1.*
FROM table1 INNER JOIN table2 ON table1.Name = table2.Name;

Thanks!

 

[Murli]

Try this:

DELETE Table1.*
FROM Table1
WHERE (((Table1.Name) In (select Name from Table2)));

 

[pablofonto]

It worked!

thank you.