I have to display ten columns values from diffrent ten
tables.
how many joins are require?
- 10 Answers
- 13061 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
Can you please explain the difference between function and stored procedure?
How to list all schemas in a database?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
what is the difference between delete table and truncate table commands? : Sql server database administration
How to download and install sql server 2005 books online?
What is single-user mode?
What is the difference between a function and a trigger?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
What are trace files?
How column data types are determined in a view?
Do you know the isolation level that sql server support?
What is the largest component inside a field?
what are the new features introduced in sql server 2000? : Sql server database administration
Benefits of Stored Procedures?
Explain transaction server isolation?
