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 is the difference between TRUNCATE and DROP?
How do I view a trc file?
What is the difference between functions and stored procedures?
What is dbcc updateusage?
What the different types of Replication and why are they used?
What is statement level trigger?
What is the difference between a clustered index and a non-clustered index?
List the advantages of using stored procedures?
What are the various editions of sql server 2017 that are available in the market?
How do you debug a procedure in sql server?
Describe different Processing Modes offered by SSRS?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
What happens if time-only values are provided as date and time literals?
What is the library index called?
What is policy based management (pbm)? : sql server database administration