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 to write a query with an inner join in ms sql server?

997


What are the types of containers in ssis?

1092


How to test a dml trigger in ms sql server?

986


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

952


What is a subquery in a select query statement in ms sql server?

1065


Why do we backup Active Directory ?

995


What is bookmark link in ssrs?

234


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3816


What is "scheduled jobs" or "scheduled tasks"?

912


Define cross join in sql server joins?

964


What are window functions in sql server?

937


Why do we use stored procedures in sql server?

895


Explain in brief about Microsoft SQL server?

1012


What are the system database in sql server 2008?

975


What do you understand by SQL*Net?

957