通过结合以下两个查询，我想获取结果配置文件，专业化为平台，Reference_Skills.Skilllookupvalue作为技能 [英] 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'

推荐答案

这篇关于通过结合以下两个查询，我想获取结果配置文件，专业化为平台，Reference_Skills.Skilllookupvalue作为技能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！