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 / sumesh.s.g

n-1 JOINS
that is 10-1 Join

Or using UNION or UNION all but its not a join

However we will get value from Tables

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can delete duplicate records in cte in sql server?

960


What is recompile sql server?

1027


How you can move data or databases between servers and databases in sql server?

1037


Describe in brief sql server monitoring ways.

1045


How many databases instances are there in sql server 2000?

1089


How you would rewrite the sql query to return the customerid sorted numerically?

982


How can I add Reporting Services reports to my application?

129


Explain the rules for designing files and file groups in sql server?

977


What is the advantage of sql server?

1026


What is page-level compression?

950


What is conditional split?

1053


Detail about the hardware which is supported by SQL server?

1056


How do you check sql server is up and running?

984


How to grant a permission in ms sql server using "grant execute" statements?

1078


What is co-related sub query?

1016