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...

How to fetch records from a One to Many relationship table.
eg: wanna get details of all orders for a specific customer.
(do not want repeatation of master table records for child
table records)

Answer Posted / jagadeesh

SubQuery

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the index requirement in SQL Azure?

92


How do I create an extended event in sql server?

904


What are various aggregate functions that are available?

914


How to drop an existing schema in ms sql server?

1023


Can we linked SharePoint to a SQL database?

971


explain different types of backups avaialabe in sql server? : Sql server database administration

919


Can a synonym name of a table be used instead of a table name in a select statement?

974


Where in ms sql server is ’100’ equal to ‘0’?

1018


What is the language structure to add a record to a table?

964


How to enter comments in transact-sql statements?

893


Explain filestream storage of sql server 2008?

951


What are the types of database schema? : sql server analysis services, ssas

1068


What is a schema in ms sql server 2005?

915


Can you move the resources after pausing the node? : sql server database administration

1042


How can I create a new template for import ? : sql server management studio

1023