n-1 JOINS that is 10-1 Join Or using UNION or UNION all but its not a j

I have to display ten columns values from diffrent ten
tables.
how many joins are require?

Question Posted / sumesh.s.g

10 Answers
14489 Views
CarrizalSoft Technologies, HCL, I also Faced
E-Mail Answers

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

Is This Answer Correct ?

2 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is filestream?

1007

List the types of recovery model available in sql server?

928

What is difference between delete & truncate commands?

1086

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

986

What is an example of a foreign key?

975

Explain an incremental backup?

1006

Can truncate be rolled back?

950

How to declare a cursor with "declare ... Cursor" in ms sql server?

1049

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

991

Which tcp/ip port does the sql server run on? How can it be changed?

1056

When would you use it?

999

In what three ways is the return statement used in a stored procedure?

1009

Define indexes?

1050

What is change data capture (cdc) in sql server 2008?

1028

Explain the commands in sql server?

1043