Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
akpaga
Constraint Violating Yak Guru
331 Posts |
 Posted - 2012-10-11 : 10:51:20
|
| Hi friends ,I have a table Customer and I would like to remove records from my select query when Customer_type is 'Regular' and Result is 'temp'.ExampleCustomername,Customer_type,Resultjohn,Regular,tempJames,Regular,permJack,Regular,tempSo from above data i just need James record..How is this done..thank you |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2012-10-11 : 11:33:51
|
| SELECT *FROM yourTableWHERE NOT (Customer_type = 'regular' and Result = 'temp')JimEveryday I learn something that somebody else already knew |
 |
|
|
akpaga
Constraint Violating Yak Guru
331 Posts |
Posted - 2012-10-11 : 11:35:10
|
| Thank you Jim |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2012-10-11 : 12:02:04
|
| You're welcome.JimEveryday I learn something that somebody else already knew |
|
|
|
|
|
|
Remove records based on two column values?