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 temporary table in sql server? Why we use temp table?

0 Answers  

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  

Explain features and concepts of analysis services?

0 Answers  

How can i Relate Tables in SSIS

0 Answers   HCL,

Name the different type of indexes in sql?

0 Answers  

How to create user messages with print statements in ms sql server?

0 Answers  

If any stored procedure is encrypted, then can we see its definition in activity monitor?

0 Answers  

How can you control the amount of free space in your index pages?

0 Answers  

What do you mean by stored techniques? How would we use it?

0 Answers  

Explain what are magic tables in sql server?

0 Answers  

How you can minimize the deadlock situation?

0 Answers  

Can a unique index be created on a column, which contains null?

0 Answers