|
peace
Constraint Violating Yak Guru
278 Posts |
 Posted - 05/24/2012 : 02:58:26
|
I have a list to pull out as below:
One way : 1
Return : 2
Connecting bus : 3
so the sample will be out like this :
Bookingtype
1
2
3
Get from same table but different column, can I still pull the data into one column?
For now there are 3 different new column as I am having error to put in one column.
,CASE FareType
WHEN 'Connecting' THEN 3
ELSE FareJType
END
"Bookingtype"
,CASE TripType
WHEN 'return' THEN 2
ELSE TripType
END
"Bookingtype1"
,CASE TripType
WHEN 'oneway' THEN 1
ELSE TripType
END
"Bookingtype2" |
|
Case when for multiple
