posted 19 years ago
Hi there,
I have some problems to understand and achieve the results I want. Let's say I have two tables, one for students and the other for courses.
I want to display the student details and the courses he/she did listed beside his/her details in the report. This will lead to two SQL statements:
select * from students
select * from courses where courses.studentID = students.studentID (which will be retrieved from the first statement)
Now, what I use for the second statement? A subreprot?
1.I want to use this report within my application, so the report will depend on the search result (same design) What to read about this?
I really appreciate any links or answers,
Thanks
