Re: [sqr-users] Embedded selects

["Larry Roux" <LRoux@syr.edu>]

No need to.  You can join tables

ie

begin-select
A.col1
A.col2
B.col3
C.col4
from table A, Table B
where A.key = B.key
end-select

Alternatively,

you can call another procedure containing the other select from a select

begin-procedure first-select
begin-select
col1
col2
  do get-other-cols
from table1
end-select
end-procedure

begin-procedure get-other-cols
begin-select
col3
col4
  do get-other-cols
from table2
end-select
end-procedure


The second option is less optimal, but less platform specific.




******************************
Larry Roux
Syracuse University
lroux@syr.edu
*******************************

>>> steve.rainbird@mssint.com 02/17/03 09:05AM >>>
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