我在下面的查询中没有正确获取配置文件 [英] i am not getting profile correctly in the below query

问题描述

SELECT distinct  TM_Profile.profile,  Reference.lookupvalue as platfrom,Reference_Skills.SkillLookupValue as skills FROM Reference
            inner join Reference_Skills on Reference.LookupID=Reference_Skills.SkillLookupKey
            inner join TM_UserAttributeValue on  Reference_Skills.SkillLookupValue=TM_UserAttributeValue.AttributeValue
            inner join TM_User on TM_UserAttributeValue.TM_UserID=TM_User.TM_UserID
            inner join TM_Profile on TM_Profile.ProfileID=TM_User.ProfileID


WHERE TM_User.Is_Active=1 and Reference.lookupkey='Platform'
and AttributeKeyType ='Skill'

编辑

---

这样我就出去了

EDIT

---

like this i am getting out put

profile platfrom skills
----------------------------------------
<pre lang="text">Admin Database Microsoft SQL Server 2005
Admin DOT NET ADO.NET Entity FrameWork
Admin DOT NET ASP.NET 2012
Admin DOT NET ASP.NET AJAX
Admin DOT NET c# 3.5

例外输出

Excepted output

profile platfrom skills
----------------------------------------
DB Developer Database Microsoft SQL Server 2005
Software engg DOT NET ADO.NET Entity FrameWork

四桌结构

Four Table Structure

/****** Object:  Table [dbo].[Reference_Skills]    Script Date: 04/30/2014 15:35:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Reference_Skills](
	[SkillID] [int] IDENTITY(1,1) NOT NULL,
	[SkillLookupKey] [varchar](max) NOT NULL,
	[SkillLookupValue] [varchar](max) NOT NULL,
 CONSTRAINT [PK_Reference_Skills] PRIMARY KEY CLUSTERED 
(
	[SkillID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[TM_Profile]    Script Date: 04/30/2014 15:35:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[TM_Profile](
	[ProfileID] [int] IDENTITY(2378,1) NOT NULL,
	[Profile] [varchar](max) NOT NULL,
	[DepartmentID] [int] NOT NULL,
	[ProfileCategoryID] [int] NULL,
 CONSTRAINT [PK_TM_Profile] PRIMARY KEY CLUSTERED 
(
	[ProfileID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Reference]    Script Date: 04/30/2014 15:35:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Reference](
	[ReferenceID] [int] IDENTITY(1,1) NOT NULL,
	[LookupID] [varchar](max) NULL,
	[LookupKey] [varchar](max) NOT NULL,
	[LookupValue] [varchar](max) NOT NULL,
 CONSTRAINT [PK_Reference] PRIMARY KEY CLUSTERED 
(
	[ReferenceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[TM_Specialization]    Script Date: 04/30/2014 15:35:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[TM_Specialization](
	[TM_SpecializationID] [int] IDENTITY(1,1) NOT NULL,
	[ProfileID] [int] NOT NULL,
	[Specialization] [varchar](200) NULL,
 CONSTRAINT [PK_TM_Specialization] PRIMARY KEY CLUSTERED 
(
	[TM_SpecializationID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  ForeignKey [FK_TM_Specialization_TM_Profile]    Script Date: 04/30/2014 15:35:42 ******/
ALTER TABLE [dbo].[TM_Specialization]  WITH CHECK ADD  CONSTRAINT [FK_TM_Specialization_TM_Profile] FOREIGN KEY([ProfileID])
REFERENCES [dbo].[TM_Profile] ([ProfileID])
GO
ALTER TABLE [dbo].[TM_Specialization] CHECK CONSTRAINT [FK_TM_Specialization_TM_Profile]
GO

推荐答案

这篇关于我在下面的查询中没有正确获取配置文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！