Interested to Buy Any Domain ? << Click Here >> for more details...
I have to display ten columns values from diffrent ten
tables.
how many joins are require?
- 10 Answers
- 14506 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 are subqueries in sql server?
What is plan freezing?
What is the filtered index?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
A trigger can reference objects outside the current database? State true or false.
How to convert numeric values to integers in ms sql server?
What is the purpose of optimization?
Can we add our custom code in ssis?
Define Wed Edition in SQL Azure?
What is the difference in accessing db between sql server vs sql azure?
What are rows and columns?
can an automatic recovery be initiated by a user? : Sql server administration
Explain the benefits of user-defined functions?
How do I debug a stored procedure in sql server?
How you can find out if an index is useful to the optimizer?
