Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Newbie : more than one ROW on one line
Hi there
Is there an elegant way - not multiple unions ... in which I can display data from parent table, and one of it's chilren on one line.
ie:
Name_Table
ID
Surnme
FirstNme
PhoneTable
ID
Phone_Type
Phone_No
Where I want to see output like...
Scott Ext:126 Home:903-3342 Cell:201-9913 Smith Ext:127 Home:904-5542 Cell:111-9443
Currently I'm doing two simple selects, and building the data on w/s. But I would like to do it in a "better" way - more logic on central server.
Any answers would be appreciated. Received on Sun Aug 06 2000 - 00:00:00 CDT