SeenGee Posted May 10, 2003 Share Posted May 10, 2003 i need to perform a select on 5 tables in a postgre db, table a is linked to table b through an \'id\' explicity created in a and linked as foreign key in b. table b creates a primary key \'number\' which is declared as a foreign key in c, d and e. each number is related to an id from table a. i want to perform a select that pulls from the database every column from every table for each instance of \'number\'. in tables c d and e there may be multiple entries for each number. Thanks Quote Link to comment https://forums.phpfreaks.com/topic/453-sql-multi-table-select/ Share on other sites More sharing options...
effigy Posted May 11, 2003 Share Posted May 11, 2003 why was this posted again? can you show us the table structures... Quote Link to comment https://forums.phpfreaks.com/topic/453-sql-multi-table-select/#findComment-1547 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.