SELECT a.FirstName, a.LastName, a.Option_Typ, b.Phone
FROM tbl_ContactDetails
There are only two types of Option_Typ (SE, CE). The above query gives the below mentioned results.
FirstName , LastName , Option_Type , Phone
Zubin , K. , SE , 371-253
Zubin , K. , CE , 431-253
Map , I. , SE , 787-676
Map , I. , CE , 543-343
I want the Result to be
FirstName, LastName, SEOptionType, CEOptionType
Zubin , K. , 371-253 , 431-253
Map , I. , 787-676 , 543-343
How I can write the query?