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 to write a query with an inner join in ms sql server?
What are the types of containers in ssis?
How to test a dml trigger in ms sql server?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is a subquery in a select query statement in ms sql server?
Why do we backup Active Directory ?
What is bookmark link in ssrs?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What is "scheduled jobs" or "scheduled tasks"?
Define cross join in sql server joins?
What are window functions in sql server?
Why do we use stored procedures in sql server?
Explain in brief about Microsoft SQL server?
What are the system database in sql server 2008?
What do you understand by SQL*Net?