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

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

Please Help Members By Posting Answers For Below Questions

How can I track the changes or identify the latest insert-update-delete from a table?

1013

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

1044

What is sql service broker?

1024

Can group by be used without aggregate functions?

966

How to create hyperlink from returned sql query ?

1183

What is report snapshot in ssrs?

280

What is the difference between system objects and user objects?

1212

What is stored in the mssqlsystemresource database? : sql server database administration

1081

What are the instances when triggers are appropriate?

1019

What is database replication?

1209

Why use stored procedures in sql server?

1058

What is a linked server in sql server?

1131

What is the maximum length of an alert name?

1038

How to view the error log for any specific instance? : sql server database administration

1098

How to create function without parameter in sql server?

1107