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
- 4854 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 olap is used?
What does the not null constraint do?
Why do you need a sql server?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Why we use functions in sql server?
What is log shipping?
What is lookup override?
explain how to create a new schema in a database? : Sql server database administration
difference between Clustered index and non clustered index ?
How many joins in sql server?
What are the basic features of a trigger in ms sql server?
What the difference between UNION and UNIONALL?
When I run the sql server 2000 setup, it just hangs. What do I do?
How to use linked server?
