SIMPLE SQL question..

rwfresh

I thought i had at worst a general understanding of SQL.. but this is driving me crazy. I simply want to grab all rows from a table where a specific field == 1 .. I have tried almost everything.. i get no SQL errors but the returned set is consistently showing me every row..

select products_too_low from PRODUCTS where products_too_low = '0'

Any ideas? thanks!

sarahk

what does products_too_low hold. I'm assuming it's a flag where 0 = no, and 1 = yes

are you really wanting

select * from PRODUCTS where id = '0'

rwfresh

First off thanks for the help.

select * from products where products_too_low = 0

This seems to be working OK. But i want to further filter out some rows.. I want to do something like this:

select p.products_id, p.products_too_low from products p, toolowtable t where t.products_id = p.products_id and p.products_too_low=0

I think that the final where condition (p.products_too_low=0)
is being ignored.. Any ideas? Thanks!