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

Answer / anil sharma

If there is no relation between tables then no joins.And if
there relation and you want to fetch related data then 9
join required if parent table has all foreign key of their
tables.

Answer / 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

Answer / srinu

No Join is required

Answer / b.kumar

--MS SQL SERVER

WE CAN DISPLAY RECORDS BY USING 9 JOINS

SELECT TBL1.COLUMN1,TBL2.COLUMN2,---------,TBL10.COLUMN10

FROM TBL1 INNER JOIN TBL2 ON TBL1.ID=TBL2.ID
INNER JOIN TBL3 ON TBL1.ID=TBL3.ID
----
----
----
INNER JOIN TBL10 ON TBL1.ID=TBL10.ID
----------------------------------------
--WE CAN ALSO DISPLAY THE RECORDS WITH OUT USE JOINS

SELECT TBL1.COLUMN1,TBL2.COLUMN2,---------,TBL10.COLUMN10
FROM TBL1,TBLE2,--------,TBL10
WHERE TBL1.ID=TBL2.ID OR TBL1.ID=TBL3.ID OR
----
----
----
TBL1.ID=TBL10.ID
--WE MUST USE WHERE CLAUSE OTHER WISE WE GET Cartesian product.

--------------------------------------------------

WE CAN'T JOIN DIFFERENT TABLES OF COLUMNS BY USING UNION

BECAUSE UNION COMBINES THE TWO OR MORE RESULT SETS
(IT MEANS ROWS)

DIFFERENCE BETWEEN JOIN & UNION

-- JOIN COMBINES TWO OR MORE THE COLUMNS
-- UNION COMBINES TWO OR MORE ROWS

Answer / ask

Select column1, column2, ...., column10 from table1,
table2, ..., table10

Answer / sumesh.s.g

n-1 JOINS
that is 10-1 Join

Or using UNION or UNION all but its not a join

However we will get value from Tables

Answer / sathish

The 10 tables can be joined as,

select table1.columnname,table2.columnname,.....
from table1,table2,.......

It displays 10 fields from 10 different tables.

Answer / sanjay kumar dinda

It will be 9( no. of tables -1)...
As we can join two tables by using two tables ...

Answer / sachin

i Think there is formula 2n-1

where n is the number of table
so, answer will be 2*10-1=19

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

17 Answers   HP,

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

Explain about SQL server 2005?

0 Answers  

What are the four main query statements?

7 Answers   Wipro,

What are the advantages of user defined function?

0 Answers  

What is difference between order by and group by?

0 Answers  

Is it possible to replicate data from sql server to oracle? : sql server replication

0 Answers  

How to attach adventureworkslt physical files to the server?

0 Answers  

Tell me what is sql profiler?

0 Answers  

How to start and end transact-sql statements?

0 Answers  

Explain Normalization and DE normalization

0 Answers   iNautix,

What are the types of stored procedures in an sql server?

0 Answers