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)
- 2 Answers
- 4893 Views
- I also Faced
- E-Mail Answers
Answer Posted / syeda
Need to define a relationship to the table and common column
of tables
ex : there is a table called college which contains the
college records like studid, studentname, batch & course.
And other table called student_details which contains
studid, firstName, lastName, fathersName, mothersName, DOB,
ContactNo & address.
Here we are fetching studid, batch, course & studentname
from collete table and DOB, ContactNo & address from
students_details , of all the students whose birth month is
April 1988
Syntax : select
a.studid,a.batch,a.course,a.studentname,b.DOB,b.ContactNo,b.address
from college a, student_details b where a.studid=b.studid
and b.DOB like '%-Apr-1988'
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Why I have to use stored procedures?
What is service broker?
What is sql server 2000 work load governor?
What is the use of for clause?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
Why truncate is ddl?
When a primary key constraint is included in a table, what other constraints does this imply?
What are the differences between char and nchar in ms sql server?
What is the sql server 2000 version number?
What is ddl and dml commands?
What is the default order of an order by clause?
What is the maximum row of a size?
When to use null data driven subscription?
How can you control the amount of free space in your index pages?
What is indexing in sql server with example?
