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 difference between oltp and olap?
What the difference between UNION and UNIONALL?
How to create view in stored procedure sql server?
How do I edit a stored procedure in sql server?
How do I schedule a sql server profiler trace?
How to transfer a table from one schema to another?
What are scalar functions?
Can we store videos inside the sql server table?
What is the new security features added in sql server 2016? : sql server security
What are distinctive joins find as a part of sql?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
what is normalization? : Sql server database administration
What are the disadvantages of using the stored procedures?
What is the default value of an integer data type in sql server 2005?
What is SQL Azure Firewall?