Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DELETE SQL Question

 
Corey McGlone
Ranch Hand
Posts: 3271
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Paul Campbell
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Delete FROM mytable A
WHERE EXISTS (SELECT 1
FROM myothertable B
WHERE A.PersonID = B.PersonID
AND A.ServiceID = B.ServiceID)
[ November 08, 2007: Message edited by: Paul Campbell ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic