delete + union 1

[aspiringprog]

hi all,

I have to delete records from some tables in sql server. Can I use a UNION command to combine two delete statements? Both these delete commands query the same table.

thanks for your help.

 

[SQLDenis]

I don't think so but you can use OR


delete Table
where condition1
or condition2

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[aspiringprog]

it works....so simple...wonder why i did not think abt it...thanks a lot