Member Avatar for achiman

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

  • 2 Contributors
  • 1 Reply
  • 99 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by drjohn
Member Avatar for drjohn

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.