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 will you monitor replication latency in transactional replication? : sql server replication

814

---

do you know how to configure db2 side of the application? : Sql server database administration

783

---

Your table has a large character field there are queries that use this field in their search clause what should you do?

692

---

what is a transaction? : Sql server database administration

646

---

What is 1nf normalization form?

741

---

---

What is 2nf normalization?

733

---

What gets stored inside msdb database?

942

---

what authentication modes does sql server support? : Sql server database administration

714

---

What is the difference between online clustering and Offline clustering?

2120

---

How do I make a resultset scrollable?

716

---

How to create new tables with "create table" statements in ms sql server?

757

---

What is difference between count (*) and count column?

664

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

744

---

What is a primary key?

695

---

What is the difference between web edition and business edition?

103

---