Ferindo Middleton Jr wrote:
Thanks Daryl. The query you wrote works perfectly for the results I was
trying to get at. I modified it a little because the real thing I needed
to be able to see is the course_title and not the the id of the courses:
SELECT
a.course_title AS class_title,
c.co
Ferindo Middleton Jr wrote:
I have a table which has two id fields which REFERENCE data back at
another table. It's setup like this:
class_prerequisite_bindings(id SERIAL, class_id INTEGER REFERENCES
classes(id), prerequisiteINTEGER REFERENCES classes(id))
The classes table is li
On Sep 14, 2005, at 8:11 PM, Ferindo Middleton Jr wrote:
I have a table which has two id fields which REFERENCE data back at
another table. It's setup like this:
class_prerequisite_bindings(id SERIAL, class_id INTEGER
REFERENCES classes(id), prerequisiteINTEGER REFERENCES class
I have a table which has two id fields which REFERENCE data back at
another table. It's setup like this:
class_prerequisite_bindings(id SERIAL, class_id INTEGER REFERENCES
classes(id), prerequisiteINTEGER REFERENCES classes(id))
The classes table is like this:
classes(idSE
