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 difference between TRUNCATE and DROP?

1108


How do I view a trc file?

924


What is the difference between functions and stored procedures?

1136


What is dbcc updateusage?

1175


What the different types of Replication and why are they used?

1045


What is statement level trigger?

965


What is the difference between a clustered index and a non-clustered index?

976


List the advantages of using stored procedures?

1030


What are the various editions of sql server 2017 that are available in the market?

881


How do you debug a procedure in sql server?

925


Describe different Processing Modes offered by SSRS?

246


Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

970


What happens if time-only values are provided as date and time literals?

994


What is the library index called?

1041


What is policy based management (pbm)? : sql server database administration

962