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

What is report snapshot in ssrs?

216


Some queries related to SQL

738


Which tools are available to manage SQL Azure databases and servers?

107


Do you know how to implement service broker?

690


How to make a remote connection in a database?

705






What is a trigger? Why we need it?

691


What is row_number()?

771


Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

735


What is service broker? : sql server database administration

742


Tell me extended events in sql server 2008?

746


Define primary key?

877


Is ssrs support other database except ms sql server?

104


What is openxml in sql server?

878


What part does database design plays a role in performance of an sql server-based application?

718


How do I setup a local sql server database?

702