I have this query that i pull the carrier mode.
But what i would like to do it so refer to the decoded carrier_mode column for each carrier ID and tell me what is the value in that specific column.
Ex: In ID
field, i could have PROWEST_32
In CARRIER_MOD decoded value i have T for TL
with this info, i would look for the value for Carrier ID PROWEST_32 in column TL and see what is the value.
It could be Y or N (Yes or No)
I don't want to have all column just the good value for the real carrier type
How can i do that?
Thanks again for your help.
DECODE(CARRIER_MODE , 'T', 'TL', 'L', 'LTL', 'I', 'INTERMODAL', 'R', 'RAIL') as CARRIER_TYPE