Complicated where condition - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Complicated where condition

Author

Topic

peace
Constraint Violating Yak Guru

420 Posts

Posted - 2012-04-17 : 22:23:03

How to select out the statement

1)All vehicle A
2)All vehicle B and C
3)All vehicle D but small only

vehicle A(list of vehicle from US)
vehicle B(list of vehicle from Japan)
vehicle C(list of vehicle from Korea)
vehicle D(list of vehicle from German)

select ... from tableName where (im stuck on my where condition)

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2012-04-17 : 22:30:15

you need to provide more information especially on the table schema.

I can only guess it is something like this


WHERE country = 'US'
or    country in ('JAPAN', 'KOAREA')
or    (country = 'GERMAN' and size = 'SMALL')

KH
[spoiler]Time is always against us[/spoiler]

peace
Constraint Violating Yak Guru

420 Posts

Posted - 2012-04-17 : 22:45:29

I get ur point.

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources