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 you can do to delete a table without the delete trigger firing?
how can you attach more than 20 ldf files in sql server
What are the advantages of mirroring?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
Why main is user defined function?
What is the recursive stored procedure in sql server?
What is always encrypted?
What are trace flags?
What command would you use to add a column to a table in sql server?
What happens if strings are casted into wrong code pages in ms sql server?
What is the meaning of sql server?
What is the difference in accessing db between sql server vs sql azure?
When would you prefer to have a minimum number of indexes?
whats the maximum size of view state??
What is the library index called?