I need to find the description and weight that is less than 5, AND greater than 10. I can'tseem to do it with one command though, so I had to use:

select description, weight from product where weight < 5;

select description, weight from product where weight > 10;


how can I merge that into one command?

 

select description, weight from product where (weight < 5 OR weight > 10);

 

Your trying to find something that is less than 5 and greater than 10 at the same time? I can't tell you regardless of the SELECT statement, your never going to get any results. You can use AND and OR operators like reno stated though to combine them. I don't know if you need the () though.

 

not necessary in that instance, but i like doing that to make my queries easier to read.

 

yes, looks good to me. i wouldn't use the () though, but that's just me.

 

I would. Even if the parser doesn't require it, the parentheses make the statement easier to read now and later.

 

I think he's trying to exclude items with a weight between 5 and 10 pounds.