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 do you mean by SQL injection attack?

1124


How many tables can be joined in SQL Server?

1111


How will you optimize a stored procedure optimization?

1111


How to update values in a table with update statements in ms sql server?

1059


What is the use of partition by in sql server?

968


Explain what is cte (common table expression)?

1183


What are different types of statement?

1082


What is the difference between left and right outer join?

1111


How do I partition a table in sql server?

1097


What are the properties of the relational tables?

925


How would you go about developing a ssrs report?

174


Explain about thread and memory management process of SQL?

1015


Explain the difference between delete,drop and truncate in SQL Server?

1159


Determine how to use the inserted and deleted pseudo tables?

1039


Tell me about builtinadministrator?

1041