I have this table:
Name Address Code James CT Homeaddress Mark firstname.lastname@example.org Email John John@hotmail.com homeemail ...
This is what I want:
Name Homeaddress Email homeemail james CT mark email@example.com john John@hotmail.com
I am creating a view and dont have privilages to alter the base tables. I was thinking maybe an IF statement might help