G
Guest
Hey guys. I need your assistance again. The query grabs name, date,
appointment # from the appointments table and links to the reports table to
get report information. The query is supposed to return the appointment info
and the first row of relevant records where the appointment # matches. The
reports table lists the appointment_num in each row of the report. A report
can be 50 lines long. Problem is, that the distinct or distinctrow operator
doesn't seem to be working.
To give you an idea:
SELECT appointments.name, appointments.data, appointments.appointment_num,
report.readingdoc, report.referringdoc
FROM appointments INNER Join reports.appointment_num on
appointments.appointment_num;
appointment # from the appointments table and links to the reports table to
get report information. The query is supposed to return the appointment info
and the first row of relevant records where the appointment # matches. The
reports table lists the appointment_num in each row of the report. A report
can be 50 lines long. Problem is, that the distinct or distinctrow operator
doesn't seem to be working.
To give you an idea:
SELECT appointments.name, appointments.data, appointments.appointment_num,
report.readingdoc, report.referringdoc
FROM appointments INNER Join reports.appointment_num on
appointments.appointment_num;