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
Explain can you implement data mining in ssrs?
Explain database normalization?
Explain the benefits of user-defined functions?
What is join and name different type of joins?
Explain the etl (extraction, transformation, and loading)?
Tell me in brief how sql server enhances scalability of the database system?
What do you mean by table and field in sql?
What is the boxing and unboxing concept in .net?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What is primary key and example?
What are the different acid properties?
How to download and install microsoft sql server management studio express?
What are orphan records?
What is openxml in sql server?
What is sql server agent and what are the two modes of authentication in sql server?