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
....

Can we call stored procedure in trigger?

999

---

How to start and end transact-sql statements?

1090

---

What are the different types of sql server replication? : sql server replication

1368

---

How to change the ownership of a schema in ms sql server?

1259

---

what are the core components of SSRS?

135

---

What is a matrix in ssrs?

158

---

What do you understand by recursive stored procedures?

1047

---

What are trace flags?

1086

---

How do I find the query plan in sql server?

1019

---

How is table type constraint applied to a table?

1030

---

Create and insert into temp table in sql server?

1084

---

How to create a simple user defined function in ms sql server?

1069

---

What are the advantages of having an index on the sql server?

977

---

What is the order in which the sql query is executed?

994

---

Explain primary key in sql server?

1074

---