I have a file that I will be importing into the database as updates are being made. The issue is the column "action" is as follows:
1,4,10 etc and when I join to "reasons" table the columns is as follows:
01, 04, 10 so therefore I am not picking up the value from the action table becasue the numbers aren't the same number of characters when it is a single digit.
Here is my join:
s.action = p0.action
-- is there a way I can correct the field in the join or do I need to do an update when importing the file in?
Thanks,
Fatisha
1,4,10 etc and when I join to "reasons" table the columns is as follows:
01, 04, 10 so therefore I am not picking up the value from the action table becasue the numbers aren't the same number of characters when it is a single digit.
Here is my join:
s.action = p0.action
-- is there a way I can correct the field in the join or do I need to do an update when importing the file in?
Thanks,
Fatisha