How to delete using SQL Advance Query with inner join?

How to delete using SQL Advance Query with inner join?

  
Hi guys,

What is the proper Query that will be put as i mentioned on my subject..Thx guys.
Usually you might want to do something like:

DELETE FROM table where
ID in ( select table.id from table inner join table2 on (condition) where other_condition )

 
SQL syntax allows joining the tables for the DELETE statement[1], but I'm not entirely sure what that means (deletes rows from both tables? only the first?), so I would play it safe :)

[1] http://technet.microsoft.com/en-us/library/ms189835.aspx
At least in recent versions of MS SQL Management Studio there is an option to convert a Join Query into a Delete Query (and even select which table to delete).
Doing the Select there you can be sure of the sintax to use.
Ricardo Silva wrote:
Usually you might want to do something like:

DELETE FROM table where
ID in ( select table.id from table inner join table2 on (condition) where other_condition )

Thanks Mr. Silva same with the MsSQL,i just want to confirm if it the with Outsystem.
Thanks again.
 
 
Ricardo Silva wrote:
SQL syntax allows joining the tables for the DELETE statement[1], but I'm not entirely sure what that means (deletes rows from both tables? only the first?), so I would play it safe :)

[1] http://technet.microsoft.com/en-us/library/ms189835.aspx

Yes Basically that is i want to do.Thanks again.