quote:

---

I m facing the problem to extract the values from table.

---

SELECT
	ud.[name] AS [name]
	, lf.[type] AS [location]
	, jt.[type] AS [Jobtype]
FROM
	user_detail ud
	JOIN locationFrom lf ON  ud.[location_from] LIKE '%' + lf.[Id] + '%'
	JOIN jobType jt ON ud.[job_type] LIKE '%' + jt.[Id] + '%'

quote:

---

Originally posted by Transact Charlie

quote:

---

I m facing the problem to extract the values from table.

---

I'm not surprised, joining these tables together is a nightmare... Can you change the schema at all?

This will give you a normalised table but performance will be terrible...

SELECT
	ud.[name] AS [name]
	, lf.[type] AS [location]
	, jt.[type] AS [Jobtype]
FROM
	user_detail ud
	JOIN locationFrom lf ON  ud.[location_from] LIKE '%' + lf.[Id] + '%'
	JOIN jobType jt ON ud.[job_type] LIKE '%' + jt.[Id] + '%'

results in.....

name,location,Jobtype
pankaj,delhi,Agent
pankaj,bombay,Agent
pankaj,madras,Agent
pankaj,delhi,account
pankaj,bombay,account
pankaj,madras,account
pankaj,delhi,Bussiness
pankaj,bombay,Bussiness
pankaj,madras,Bussiness

-------------
Charlie

---

user_detail(id varchar(50),name varchar(50))
user_detail_location(id varchar(50) ,location_from varchar(max))
user_detail_job_type(id varchar(50) ,job_type varchar(max))