Delete from X where x.ID=(Select from Y where y.id=123) 1

[benlinkknilneb]

Does anyone know a good way to accomplish this?

I have a table (X) which has a primary key. This is referenced in another table (Y) that has its own primary key.

I want to delete everything in X that's related to Y, given Y's primary key.

I'm writing a VB app to feed the SQL to the database, so it's possible for me to loop through them all but I was hoping that someone with better SQL-fu than I could craft a statement to handle it.

Ben
Windows isn't the answer; it's the question. NO is the answer.

 

[lgarner]

Close. Try:

delete from X where x.ID in (Select x_id from Y where y.id=123);

 

[benlinkknilneb]

Perfection. Have a star.

Ben
Windows isn't the answer; it's the question. NO is the answer.