posted 16 years ago
So I have two tables, A and B, and I'd like to delete all records from A in which two of the columns match two columns in B - here's what my tables look like:
There are more columns in each table, but these are the ones I'd like to matc upon. When all is said and done, I'd like table A to look like this:
I'm a little unsure on how to write the SQL. I think I can do this:
I think that'll work, but I don't really like the syntax. It just doesn't seem obvious to me what that query will do and I'd like to have somewhat more readable SQL.
Any advice on a straightforward way to do this deletion?
Thanks,
Corey