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
How can delete duplicate records in cte in sql server?
What is recompile sql server?
How you can move data or databases between servers and databases in sql server?
Describe in brief sql server monitoring ways.
How many databases instances are there in sql server 2000?
How you would rewrite the sql query to return the customerid sorted numerically?
How can I add Reporting Services reports to my application?
Explain the rules for designing files and file groups in sql server?
What is the advantage of sql server?
What is page-level compression?
What is conditional split?
Detail about the hardware which is supported by SQL server?
How do you check sql server is up and running?
How to grant a permission in ms sql server using "grant execute" statements?
What is co-related sub query?