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

What is difference between oltp and olap?

1031


What the difference between UNION and UNIONALL?

1032


How to create view in stored procedure sql server?

1009


How do I edit a stored procedure in sql server?

914


How do I schedule a sql server profiler trace?

968


How to transfer a table from one schema to another?

993


What are scalar functions?

992


Can we store videos inside the sql server table?

959


What is the new security features added in sql server 2016? : sql server security

1097


What are distinctive joins find as a part of sql?

944


What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1038


what is normalization? : Sql server database administration

1083


What are the disadvantages of using the stored procedures?

1088


What is the default value of an integer data type in sql server 2005?

942


What is SQL Azure Firewall?

136