I have to display ten columns values from diffrent ten
tables.
how many joins are require?
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
What is nolock hint in sql server 2008
How to retrieve field values using mssql_result()?
What is the use of sql profiler in sql server 2012?
How and why use sql server?
What is database black box testing?
how many no of arguments can be passed in procedures and functions
To which devices can a backup be created and where should these devices be located? : sql server management studio
Explain subquery and state its properties?
When would you use sql joins?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What is normalization and what are the advantages of it?
What is entity data services?
Explain Reporting Life Cycle?
What do you mean by sql server agent?
What is a ddl statement?