How to fetch records from a One to Many relationship table. eg: wanna get deta

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)

Question Posted / shoab shah

2 Answers
4013 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders fo..

Answer / 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

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders fo..

Answer / jagadeesh

SubQuery

Is This Answer Correct ?

0 Yes

4 No

Post New Answer