SELECT distinct(students.fname), courses.title AS course FROM students,
courses,
> course_enrolments, groups, locations, staff WHERE
> (students.studentID=course_enrolments.studentID AND
> course_enrolments.courseID=courses.courseID) AND
> (students.groupID=groups.groupID) AND (staff.staffID=courses.staffID)
ORDER
> BY fname ASC
should do iy
Steve
"Beau Lebens" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi guys, I have a set-up to query a database by allowing the user to build
a
> query from selecting fields, restrictions etc etc.
>
> It produces the following;
>
> SELECT students.fname, courses.title AS course FROM students, courses,
> course_enrolments, groups, locations, staff WHERE
> (students.studentID=course_enrolments.studentID AND
> course_enrolments.courseID=courses.courseID) AND
> (students.groupID=groups.groupID) AND (staff.staffID=courses.staffID)
ORDER
> BY fname ASC
>
> which gets the right results, but it returns something like this;
>
> +-------+------------------------------------------------------+
> | fname | course |
> +-------+------------------------------------------------------+
> | Beau | Graduate Certificate in Learning Technologies (K-12) |
> | Beau | Graduate Certificate in Learning Technologies (K-12) |
> | Grant | Short Course in Learning Technologies (K-12) |
> | Grant | Short Course in Learning Technologies (K-12) |
> +-------+------------------------------------------------------+
>
> and it should only be returning one of each of those records.... any
> suggestions?
>
> thanks
>
> Beau
>
>
> --
> Beau F Lebens, Technical Officer
> National Key Centre for School Science and Mathematics
> Science and Mathematics Education Centre
> Curtin University of Technology,
> GPO Box U1987 Perth, Western Australia 6845
>
> t: +61 8 9266 7297 (has voice-mail)
> f: +61 8 9266-2503 (ATT: Beau Lebens)
> e: [EMAIL PROTECTED]
> w: http://learnt.smec.curtin.edu.au/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
