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

Answer Posted / sachin

i Think there is formula 2n-1

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

Is This Answer Correct ?    2 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What stored by the master?

635


Define primary key?

764


Should you normalize audio?

625


Explain ms sql server reporting services vs crystal reports?

581


What is key attribute?

607






What are the different sql server versions?

594


What to perform pattern match with the like operator?

564


How to create new tables with "select ... Into" statements in ms sql server?

581


What are the different types of normalization?

725


Why I am getting this error when dropping a database in ms sql server?

679


What does this statement do @@rowcount?

649


What is a bit datatype?

651


What is a partition key?

593


What is the use of for clause?

667


What is hot add cpu in sql server 2008?

603