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 |
|
S3RG3
Starting Member
2 Posts |
 Posted - 2010-09-23 : 00:18:48
|
| Hi everyone, I am trying to run a query which will take all data that specifies a few different parameters such as SELECT ____ FROM ____WHERE condition 1 AND condition 2 AND condition 3But condition 3 has to be 2 conditions satisfied together.e.g. SELECT data FROM table WHERE height=x AND width=y AND (not lenght=a and width=y together)I am trying to get all records with height x, width y, but not records with width y and lenght a...Any help will be appreciated.Thanks! |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-09-23 : 00:20:40
|
| [code]SELECT data FROM table WHERE (height=x AND width=y) AND (lenght<>a and width<>y)[/code]PBUH |
 |
|
|
S3RG3
Starting Member
2 Posts |
Posted - 2010-09-23 : 00:28:05
|
| Thanks mate! |
|
|
|
|
|
|
Query with __ AND __ AND (two conditions)