SQL WHERE Clause Question - 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

SQL Server 2000 Forums

Transact-SQL (2000)

SQL WHERE Clause Question

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-10-04 : 10:13:06

Debrah writes "is there a way to nest multiple WHERE clauses in a select statement. For example:

I wanted to try something like:

Select CustType, Priority, ModDate, DTLastModified, RecvDate
FROM CallLog
WHERE Priority ='o'
WHERE ModDate >1 RecvDate

This is just an example of the question. Is there a clever way of doing this, or it just cannot be done. Let me know your thoughts. I'm trying to do something along the lines of concantenating WHERE clauses if that can be done. This way I do not have to make multiple SELECT statements/queries if I can accomplish something like this in one statement.

Thanks in advance guys
Deb"

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-10-04 : 10:16:10

Select CustType, Priority, ModDate, DTLastModified, RecvDate
FROM CallLog
WHERE Priority ='o' and
ModDate >1 RecvDate

Jay White
{0}

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources