[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Embedded selects

Steve,

I forgot the table join...


...
from taba a, tabb b
where a.some_cola = b.some_colb

end-select



-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On
Behalf Of Steve Rainbird
Sent: Monday, February 17, 2003 9:06 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Embedded selects


Hello everybody,

I apologise if this is a stupid question but I am a complete newbie to SQR.
I have been an Oracle PL/SQL, ProC,ProCobol etc developer for many years, so
that why I ask this question.

Is it possible to have a select within a select.

i.e.

begin-select
col1
col2
begin-select
col3
col4
from taba
from tabb
end-select
end-select

Thanks in advance

Regards

Steve Rainbird

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users