Re: [sqr-users] Subselect

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

Yes, just put a variable at the end of the subselect - ie

begin-select
A.DATE
(select ID from TABLE_X where NAME = 'FRED') &ID
A.ADDRESS_LINE1
   show ' Date = ' &A.DATE  ' ID = ' &ID 
from ADDRESSES A
where A.ADDRESS_TYPE = 'HOME'
end-select








Larry Roux
Syracuse University
lroux@syr.edu

>>> CAllo@hinda.com 07/07/04 16:28 PM >>>




I don't have very detailed information on the begin-select construct and my
question is as follows:  In SQL, you can do "subselects" like

SELECT
Date,
(Select total From Acct Where...),
Name,
......
FROM
......


I am wondering if it is possible to accomplish something of the sort in a
begin-select paragraph?

Christopher Allo
PeopleSoft Specialist
x-3348
This communication is for the exclusive use of addressee and may contain
confidential, proprietary or privileged information which may be used
exclusively for its intended purpose. If you are not the intended
recipient, any use, copying, disclosure, dissemination or distribution is
strictly prohibited.  If you are not the intended recipient, please notify
the sender immediately by return e-mail, delete this communication, and
destroy all copies.


_______________________________________________
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