CODEWITHSUNDEEP
sql-server-2008
Pankaj Sharma
Pankaj Sharma

Reputation: 254

SQL Query to achieve following output

I am having following tables as provided in given image below. Please write a sql query to to achieve required output.

enter image description here

Write a Single Select Statement to achieve this output.

Upvotes: 2

Views: 22

Answers (1)

Jitendra Pancholi
Jitendra Pancholi

Reputation: 7562

Try below query...

Select m.Id,Name=Case
CID
When 1 Then (Select t1.Name from Table1 t1 Where m.Id=t1.Id)
When 2 Then (Select t2.Name from Table2 t2 Where m.Id=t2.Id)
When 3 Then (Select t3.Name from Table3 t3 Where m.Id=t3.Id)
When 4 Then (Select t4.Name from Table4 t4 Where m.Id=t4.Id)
END
from MasterTable m

Upvotes: 3

Related Questions