|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
August 21st, 2003, 01:46 PM
|
|||
|
|||
|
SQL help please
Hi,
I'm a little stuck with this query I'm working with. I'm trying to return products that have a value in one or both of two fields. If there is a value in both fields, return this product twice. Here is a lame example: If the product is a fruit, return its number. or If its a vegetable, return its number. or If its both, then return its number twice. Can this be done in one query? This is probably something simple but I cant seem to figure it out. Thanks, for the help!
|
|
#2
August 21st, 2003, 07:06 PM
|
|||
|
|||
|
return number twice? as in same row?
Code:
select case
when (p.veg= '1'
and p.fru = '1')
then p.id + ',' + p.id
else
p.id
end
from products as p
|
|
#3
August 21st, 2003, 07:56 PM
|
|||
|
|||
|
ya, the row would return twice
|
|
#4
August 21st, 2003, 09:03 PM
|
||||
|
||||
|
select productnumber from products
where fruit='yes' UNION ALL select productnumber from products where vegetable='yes' UNION ALL returns all rows from both selects, where UNION would have eliminated the dupe rudy http://r937.com/
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > SQL help please |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
