Home » RDBMS Server » Server Administration » select within a select
select within a select [message #371204] Thu, 14 September 2000 21:11 Go to next message
Shane
Messages: 27
Registered: December 1999
Junior Member
I come from sybase and this example select statement was ok:

select id, name, (select phone_num from phone where id = e.id)
from employee e

I tried this in oracle and it gave me an error. Does anyone know how I can do something similar in oracle. Thanks in advance.

Report message to a moderator

Re: select within a select [message #371205 is a reply to message #371204] Fri, 15 September 2000 04:16 Go to previous message
Vjeko
Messages: 15
Registered: August 2000
Junior Member
select e.id,e.name,p.phone_num
from employee e,phone p
where p.id=i.id;

Report message to a moderator

Previous Topic: Re: Installing Oracle 8
Next Topic: sql
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 12:55:42 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.