SELECT

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