I have this table:
Name Address Code James CT Homeaddress Mark email@example.com Email John John@hotmail.com homeemail ...
This is what I want:
Name Homeaddress Email homeemail james CT mark firstname.lastname@example.org 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