Are you looking for something trivial like: select n.first_name, 'E.' middle_initial,n.last_name,m.mem_init_sequence from names n, member m where n.first_init=m.mem_first_init and n.second_init=m.mem_second_init order by 1 desc, 2 asc;
On 2002.06.08 01:33 Viktor wrote: > Hello All, > > It looks as if I've hit a brick wall and I'd very much > appreciate if you can help. I've got a query that has > to get some names and tie them to members. Name table > is the main table with and member table is child > table. > > desc Names > > FIRST_INIT NOT NULL CHAR(4) > SECOND_INIT NOT NULL CHAR(1) > INIT_SEQUENCE NOT NULL NUMBER > LAST_NAME VARCHAR2(30) > FIRST_NAME VARCHAR2(20) > FLAG NOT NULL NUMBER > > desc MEMBER > > MEM_FIRST_INIT CHAR(4) > MEM_SECOND_INIT CHAR(1) > MEM_INIT_SEQUENCE NUMBER > > Member table references Names table on FIRST_INIT, > SECOND_INIT, INIT_SEQUENCE. > > > > > > __________________________________________________ > Do You Yahoo!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Viktor > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).