Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

Where is trigger in sql server?

984


How can sql injection be stopped? : sql server security

954


Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

850


Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1000


What do you understand by integration services in sql server?

919


What is candidate key with example?

922


Mention the uses of stored procedures.

927


Can you edit the .rdl code associated with a linked report?

149


While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

983


Explain about Normalization?

1011


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

1755


What is Federation Root Database?

104


Can a unique index be created on a column, which contains null?

877


What is a view and what are its advantages?

1052


In what sequence sql statement is processed?

952