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 -> SELECT

SELECT

From: <bing-du_at_tamu.edu>
Date: Sun, 28 Jan 2001 21:00:17 GMT
Message-ID: <95218v$al2$1@nnrp1.deja.com>

In one of my cgi program, I need to query the Oracle database for some data. Here is my question.

table1:

name phonenumber
---- ----------

one 111
two 222

table2:

name age
---- ---

one 33

select table1.name,table1.phonenumber,table2.age from table1,table2 where table1.name=table2.name;

From my understanding, the above SELECT statement only returns the the following result:

name phonenumber age
---- ----------- ---

one 111 33

My question is how I can get the following result?

name phonenumber age
---- ----------- ---

one 111 33
two 222

Any help would be appreciated!

Bing

Sent via Deja.com
http://www.deja.com/ Received on Sun Jan 28 2001 - 15:00:17 CST

Original text of this message

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