Answer Posted / praveen mehta

There are 2 possible answers
1. No joins required

Ex:
SELECT Col1 As Col from Tab1
Union
SELECT Col2 As Col from Tab2
Union
SELECT Col1 As Col from Tab3
...

2. 9 Joins Required
Ex:
SELECT
t1.Col1,
t2.Col2,
....
FROM Tab1 t1
inner join Tab2 t2 on t1.Col1=t2.Col2
inner join Tab3 t3 on t1.Col1=t3.Col2
....

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

992

---

How to handle error or exception in sql?

983

---

Do you know what guidelines should be followed to help minimize deadlocks?

970

---

What number sorts of privileges are accessible in sql?

1037

---

What are trace files?

959

---

Define right outer join?

983

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1162

---

Explain throw statement in sql server 2008?

998

---

What is the tcp/ip port on which sql server runs?

1161

---

How many replicas are maintained for each SQL Azure database?

142

---

What is 2nf normalization?

1029

---

How to replace the Query Result 'Null Value' with a text ?

1043

---

What do you need to connect php to sql server?

1105

---

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

145

---

What is buffer cash and log cache in sql server?

1125

---