By Combining Below Two Query's I Want To Fetch The Result Profile ,Specialization As Platfrom,Reference_Skills.Skilllookupvalue As Skills

select profile ,Specialization as platfrom from TM_Profile
inner join dbo.TM_Specialization on TM_Profile.ProfileID=TM_Specialization.ProfileID

SELECT distinct Reference_Skills.SkillLookupValue as skills FROM Reference
join Reference_Skills on Reference.LookupID=Reference_Skills.SkillLookupKey
join TM_UserAttributeValue on  Reference_Skills.SkillLookupValue=TM_UserAttributeValue.AttributeValue
where Reference.lookupkey='Platform'  and AttributeKeyType ='Skill'