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
What stored by the master? : sql server database administration
What is bcp? When does it use?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
What is fill factor and pad index?
Can I work with several databases simultaneously? : sql server management studio
What is the maximum number of index per table?
What are data driven subscriptions?
How to get nth highest salary from employee table.
What is a benefit of using an after insert trigger over using a before insert trigger?
Name 3 ways to get an accurate count of the number of records in a table?
What is a transact-sql statement?
What is stretch database in sql server?
When does a workload on SQL Azure get throttled?
Explain the concept of recursive stored procedure.
Explain security with sql azure?