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

Answer Posted / sanjay kumar dinda

It will be 9( no. of tables -1)...
As we can join two tables by using two tables ...

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I setup a local sql server database?

535


How to create a simple table to test triggers in ms sql server?

507


Do you know what are the properties of the relational tables?

573


How to include text values in sql statements?

586


Why use sub query in sql server and list out types of sub queries?

539






What is 4nf in normalization form?

562


Describe triggers features and limitations?

502


Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

78


Tell me what is the significance of null value and why should we avoid permitting null values?

547


What is the sql profiler?

539


How the authentication mode can be changed?

604


what are defaults? : Sql server database administration

515


What are acid properties of transaction?

549


What is a database table?

517


What is coalesce and check constraint in sql server?

539