SQL Help

[jasontung]

Hi
I am new to SQL and when using the
'select * from whatever where columnname = whatever'
can I have 2 of the 'where' parts

So instead of having 1 condition like here, can I have 2 conditions?

Thank you

[Sony]

hi,
sure you can have many conditions like:

select *
from customer
where state = 'NJ'
and id = 123

just keep using the AND keyword to add another condition to the where clause.

[jasontung]

OK, Thank you for the relpy

[doctorgonzo]

You can have as many as you want, connecting AND, OR and NOT. You can usually use things like BETWEEN as well, depending on the implementation. Use parentheses to make things clear.

In some of the queries I have constructed, I have lots of where clauses, such as selecting all the people whose addresses start with this and who ordered between these to dates and who haven't received their order yet but have paid. That kind of thing.

[jasontung]

Thank you
I see now