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'

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

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

/****** 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