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 index requirement in SQL Azure?
How do I create an extended event in sql server?
What are various aggregate functions that are available?
How to drop an existing schema in ms sql server?
Can we linked SharePoint to a SQL database?
explain different types of backups avaialabe in sql server? : Sql server database administration
Can a synonym name of a table be used instead of a table name in a select statement?
Where in ms sql server is ’100’ equal to ‘0’?
What is the language structure to add a record to a table?
How to enter comments in transact-sql statements?
Explain filestream storage of sql server 2008?
What are the types of database schema? : sql server analysis services, ssas
What is a schema in ms sql server 2005?
Can you move the resources after pausing the node? : sql server database administration
How can I create a new template for import ? : sql server management studio