RE: [sqr-users] Embedded selects

[Bruce Kelling <Bruce_Kelling@advantechsolutions.com>]

Yes, but not that way.

Begin-Procedure1
Begin-select
col1
Col2

                Do Procedure2

from taba
End-Select
End-Procedure1

!---------------------------------

Begin-Procedure2
begin-select
col3
Col4

from tabb
End-Select
End-Procedure2

This is the most common technique.  For each row selected in Procedure1,
procedure2 is called.
You can also have subqueries, unions, and large data arrays.  You might want
to review some of the sample programs that come with SQR.
 
Bruce


-----Original Message-----
From: Steve Rainbird [mailto:steve.rainbird@mssint.com] 
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