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
- 14488 Views
- CarrizalSoft Technologies, HCL, I also Faced
- E-Mail Answers
Answer Posted / anil sharma
If there is no relation between tables then no joins.And if
there relation and you want to fetch related data then 9
join required if parent table has all foreign key of their
tables.
| Is This Answer Correct ? | 29 Yes | 2 No |
Post New Answer View All Answers
What is the recovery model?
What is sql server schema compare? How we can compare two database schemas?
How do we synchronize On-Premise SQL server with SQL Azure?
Write a program using SQL queries to find a unique entry in a table.
Tell me what is use of except clause? How it differs from not in clause?
How many database files are there in sql server 2000?what are they?
what is memory-optimized nonclustered indexes
What are rows and columns?
What does select 1 mean?
How do I setup a local sql server database?
What are the dis_advantages of stored procedures, triggers, indexes?
What are the restrictions while creating batches in sql server?
What is scrollable cursor?
What are the steps to follow to configure SQL*Net?
How to test a dml trigger in ms sql server?
