SQL question
Posted: Thu Aug 21, 2003 5:04 pm
I am try to query 1 row of data based on a range.
when I ran this query:
I get no rows returned.
if I ran this query:
I get all the rows.
Is there a better way to write the query.
when I ran this query:
Code: Select all
SELECT * FROM packaging WHERE amin >= 4 AND amax <= 4if I ran this query:
Code: Select all
SELECT * FROM packaging WHERE amin >= 4 OR amax <= 4Is there a better way to write the query.