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

it is correct.

you can have as many conditions as you wish in the WHERE

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.