deepu.surya Warnings : 1 New User
Joined: 01 Apr 2008 Posts: 10 Location: hyderabad
|
|
|
|
Hi all,
I need to delete two differnet records in a table. The unique index combination is two columns (lets say colA, colB). Is there any way where i can include these two conditions in single SQl..
SQL 1:
delete from table
where colA = A and
where colB = B
SQL 2:
delete from table
where colA = C and
where colB = D
Can i combine SQL 1 and SQL2 assuming there wil be some records with cross references like (colA = A and colB = D will give me a record) |
|