note 35445 added to function.ociresult

if you want to join two tables having both the same column (e.g. 'id') but you don't want to (or cannot) specify all the other fields in these two tables (like erabbott mentioned), you can use: SELECT t1.*, t2.*, t1.id AS id1, t2.id AS id2 FROM table1 t1, table2 t2; Note that this does _not_ work: SELECT *,t1.id AS id1, t2.id AS id2 FROM table1 t1, table2 t2; ---- Manual Page -- http://www.php.net/manual/en/function.ociresult.php Edit Note -- http://master.php.net/manage/user-notes.php?action=edit+35445 Delete Note -- http://master.php.net/manage/user-notes.php?action=delete+35445&report=yes Reject Note -- http://master.php.net/manage/user-notes.php?action=reject+35445&report=yes