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

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

944

---

Do you know what are acid properties of transaction?

909

---

What are the different types of data sources in ssrs?

188

---

What are the basic functions for master, msdb, model, tempdb and resource databases?

938

---

What is the difference between value type and reference type?

870

---

Why are sql functions used?

1044

---

How do you open a cluster administrator?

1001

---

What happens if time-only values are provided as date and time literals?

953

---

Can we use trigger new in before insert?

865

---

what types of replication are supported in sql server? : Sql server database administration

954

---

Why truncate is ddl?

1028

---

what are different types of raid configurations? : Sql server database administration

994

---

What are logical database components? : SQL Server Architecture

959

---

What are partitioned views?

939

---

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

888

---