[GENERAL] query or schema question

2004-12-14 Thread Scott Frankel
My first schema design has passed all the tests I've thrown it so far, 'cept one -- and a simple one at that. I wonder if the following boils down to a question of query construction or if I need to redesign my schema. Consider the (contrived) example of 3 universities, where each hosts a *uni

Re: [GENERAL] query or schema question

2004-12-14 Thread Michael Fuhr
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