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

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

Explain can you implement data mining in ssrs?

106


Explain database normalization?

645


Explain the benefits of user-defined functions?

522


What is join and name different type of joins?

578


Explain the etl (extraction, transformation, and loading)?

558






Tell me in brief how sql server enhances scalability of the database system?

522


What do you mean by table and field in sql?

552


What is the boxing and unboxing concept in .net?

544


You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

99


What is primary key and example?

502


What are the different acid properties?

622


How to download and install microsoft sql server management studio express?

561


What are orphan records?

545


What is openxml in sql server?

614


What is sql server agent and what are the two modes of authentication in sql server?

541