Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Newbie : more than one ROW on one line

Newbie : more than one ROW on one line

From: Walter W <clothahump_at_usa.net>
Date: 2000/08/06
Message-ID: <8mk0uq$1sq5$1@nnrp01.ops.uunet.co.za>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US