brettanderson77
asked on
ACESS SQL Deleting from a table where values exist in another table
Hi,
I need to delete all from table A where attribute X exists in both table A & table B.
Hope you can help.
Cheers,
Brett
I need to delete all from table A where attribute X exists in both table A & table B.
Hope you can help.
Cheers,
Brett
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
note that the EXISTS() method is usually more performant...
anyhow, glad we could help
anyhow, glad we could help
ASKER