adspace


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / anil sharma

Answer Posted / anil sharma

If there is no relation between tables then no joins.And if
there relation and you want to fetch related data then 9
join required if parent table has all foreign key of their
tables.

Is This Answer Correct ?    29 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the source of constraints?

1008

What are wait types?

1248

What are the different types of subquery?

1233

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1022

What are the properties of the transaction?

1070

How efficient you are in oracle and SQL server?

1255

Why and when do stored procedure recompile?

1056

What is sql or structured query language?

1226

What is in place upgrade in sql server?

1125

Equi join and non equi join is possible with sql server?

1133

How can I check that whether automatic statistic update is enabled or not?

1111

What are the different subsets of sql?

1648

How do I start sql server 2017?

1015

How to provide default values to function parameters?

1256

Why should you use or avoid select * statements?

1108