I have to display ten columns values from diffrent ten
tables.
how many joins are require?
- 10 Answers
- 11965 Views
- CarrizalSoft Technologies, HCL, I also Faced
- E-Mail Answers
Answer Posted / nitin
there are 3 answeres
1. No joins are required if do not want to display related
data
2. 9 joins are requred if all tables are related
3. no joins reuquired we can use union if condition is
like following
select cola from a
union
select colb from b
union
select colc from c
.
.
.
like wise ten statements
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How ssrs maintain security?
Which is faster statement or preparedstatement?
List out the differences between global and local temp tables in sql server?
What is side by side migration in sql server?
How to create a simple stored procedure in ms sql server?
What are sql server functions?
What is the use of keyword with encryption.
what is a traditional network library for sql servers? : Sql server database administration
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
How efficient you are in oracle and SQL server?
Can coalesce return null?
Explain what is the use of custom fields in report?
Explain datetime2 data type in sal server 2008?
What is coalesce and check constraint in sql server?
