Constraint Violating Yak Guru
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 :
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.
WHEN 'Connecting' THEN 3
WHEN 'return' THEN 2
WHEN 'oneway' THEN 1