kat50
asked on
Delete QUery Help Needed for items in multiple tables
Guidence needed on delete query. I want to delete all items in table 1 that are in table 2.
select * from table 1
table1 join on table2 table1.c#=table2.C# works. when I add delete * instead of the select it grumbles...
select * from table 1
table1 join on table2 table1.c#=table2.C# works. when I add delete * instead of the select it grumbles...
You don't need the * for delete, as you can't delete specific columns you can only delete the whole row.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Even though you obviously completely ignored my comment, just thought i'd point out that using IN is a lot slower than using JOIN syntax.