I have to display ten columns values from diffrent ten
tables.
how many joins are require?
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
Where is trigger in sql server?
How can sql injection be stopped? : sql server security
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What do you understand by integration services in sql server?
What is candidate key with example?
Mention the uses of stored procedures.
Can you edit the .rdl code associated with a linked report?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
Explain about Normalization?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
What is Federation Root Database?
Can a unique index be created on a column, which contains null?
What is a view and what are its advantages?
In what sequence sql statement is processed?