954,597 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

select statement

Please is it possible to have two where statement in an sql query? for example:
SELECT * FROM Persons WHERE FirstName='Peter'

but I want another condition which will also pass the query like:

SELECT * FROM Persons WHERE house='duplex' or car='Honda'

Is the second query correct if not how do I write it?
Thanks

achiman
Junior Poster in Training
51 posts since Mar 2009
Reputation Points: 10
Solved Threads: 0
 

you can use that

debasisdas
Posting Genius
6,872 posts since Feb 2007
Reputation Points: 666
Solved Threads: 434
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You