Hi,
SQL is not my main area of expertise so I need some help.
I have the following table (PhonePerson) which contains 5 columns:
PersonGUI (PK, Employee ID)
PhoneType (MOBILE,DAY,FAX,HOME)
PhoneID (1=MOBILE, 2=DAY, 3=FAX, 4=HOME)
AreaCode (Area code, ex 415)
Phone (Phone #, without area code, ex 444-4444).
I need to generate a sql that checks to see if an employee has a value for 'MOBILE' and if it does it needs to return AreadCode+' '+Phone in a column called 'Phone' for that employee. If there is no value for 'MOBILE' for a certain employee it instead needs to return the value for 'DAY' by AreaCode+' ' +Phone in the 'Phone' column.
Any help is greatly appreciated!
Thanks!