Re: [SQL] showing multiple reference details from single query

2005-09-11 Thread Michael Fuhr
On Sun, Sep 11, 2005 at 06:37:52PM -0400, Ferindo Middleton Jr wrote: > table_one has the following columns: > id (SERIAL), column_one (INTEGER REFERENCES table_two(id)), column_two > (INTEGER REFERENCES table_two(id)) > > table_two has the following columns: > id (SERIAL), more_detailed_info (TE

[SQL] showing multiple reference details from single query

2005-09-11 Thread Ferindo Middleton Jr
I have a table (table_one) with two columns, both of which are integers which reference the same column (on a one-to-many relationship) row back at another table (table_two) which has more detailed info on these integer columns: table_one has the following columns: id (SERIAL), column_one (INT