On Tue, Dec 14, 2004 at 07:23:31PM -0800, Scott Frankel wrote: > is there a reasonable way to traverse the dependencies from the > students table back to the universities table?
See the documentation for joined tables in the Tutorial and in the SQL Language documentation. It sounds like you want to join the students table to departments, and departments to universities. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html