View Single Post
Old Oct 27, 2004 | 05:29 PM
  #1  
ManInCamo's Avatar
ManInCamo
Old School Crew
 
Joined: May 2000
Posts: 5,251
Likes: 0
Default anyone know SQL?

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?
Reply