Hi,

You find below a solution:

SELECT

com.IDAS ID,

com.FnameAS Fname,

com.LnameAS Lname,

com.AgeAS Age,

com.SexAS Sex,

com.LocationAS Location,

CASE WHEN EXISTS (SELECT '1' FROM tblCommon_tblSkills comski

left JOIN tblskills ski ON comski.skill_id=ski.id WHERE comski.common_id=com.id AND ski.id=1) THEN 'Yes' ELSE 'No' END AS MSOffice,

CASE WHEN EXISTS (SELECT '1' FROM tblCommon_tblSkills comski

left JOIN tblskills ski ON comski.skill_id=ski.id WHERE comski.common_id=com.id AND ski.id=2) THEN 'Yes' ELSE 'No' END AS SharePoint,

CASE WHEN EXISTS (SELECT '1' FROM tblCommon_tblSkills comski

left JOIN tblskills ski ON comski.skill_id=ski.id WHERE comski.common_id=com.id AND ski.id=3) THEN 'Yes' ELSE 'No' END AS 'ASP.Net',

CASE WHEN EXISTS (SELECT '1' FROM tblCommon_tblSkills comski

left JOIN tblskills ski ON comski.skill_id=ski.id WHERE comski.common_id=com.id AND ski.id=4) THEN 'Yes' ELSE 'No' END AS 'C#',

CASE WHEN EXISTS (SELECT '1' FROM tblCommon_tblSkills comski

left JOIN tblskills ski ON comski.skill_id=ski.id WHERE comski.common_id=com.id AND ski.id=5) THEN 'Yes' ELSE 'No' END AS 'J2EE',

CASE WHEN EXISTS (SELECT '1' FROM tblCommon_tblSkills comski

left JOIN tblskills ski ON comski.skill_id=ski.id WHERE comski.common_id=com.id AND ski.id=6) THEN 'Yes' ELSE 'No' END AS SQLServer,

CASE WHEN EXISTS (SELECT '1' FROM tblCommon_tblSkills comski

left JOIN tblskills ski ON comski.skill_id=ski.id WHERE comski.common_id=com.id AND ski.id=7) THEN 'Yes' ELSE 'No' END AS Oracle

FROM

tblcommon com

The results are the following:

IDFnameLnameAgeSexLocationMSOfficeSharePointASP.NetC#J2EESQLServerOracle

1KishoreP37mhydYesYesYesYesNoYesNo

2KotiR28mhydYesYesYesYesYesYesYes

3RameshB30mhydYesNoYesYesNoYesNo