Answer Posted / nitin

there are 3 answeres
1. No joins are required if do not want to display related
data
2. 9 joins are requred if all tables are related
3. no joins reuquired we can use union if condition is
like following
select cola from a
union
select colb from b
union
select colc from c
.
.
.
like wise ten statements

How to enter date and time literals in ms sql server?

1006

---

Explain the concept of recursive stored procedure.

932

---

How to remove duplicate rows from table?

1237

---

What is outer join in sql server joins?

1106

---

What do you understand by triggers and mention the different types of it?

915

---

List the data types available in mssql?

1024

---

How to use values from other tables in update statements in ms sql server?

1100

---

Can group functions be mixed with non-group selection fields in ms sql server?

932

---

How many partitions a clustered index has by default in sql server 2012?

1081

---

How to create a user to access a database in ms sql server using "create user" statements?

941

---

How each E-R model constructs can be mapped to the relational model?

991

---

What is database isolation in sql server? : sql server database administration

1092

---

What are the advantages of sql stored procedure?

1060

---

What are the tool windows in sql server management studio? : sql server management studio

1064

---

what are the three command line utilities and what are their primary functions?

144

---