Jim,
Can't do that. Someone recently requested something like it as an
enhancement. You can select from another table based on the
values returned by the sub-select, but those values can't be stored
in a variable.
Ben Petersen
On 22 Jun 2001, at 9:36, Jim Limburg wrote:
> G-Day all
>
> I started out this morning to do what I thought a simple thing. To build
> a sub-select statement that would return into a variable the values in a
> column that are not null and distinct even if it is in the column more
> than once..
>
> I want the variable to contain 6090,7010,4050,1320,1590 ... and so on...
>
> The data in the columns is text/12 and here is what I attempted so far.
>
> SELECT gl_acct INTO vg_gl_acct FROM gl_pur_01 WHERE gl_acct IN +
> (SELECT gl_acct FROM gl_pur_01 where gl_acct is not null and limit=1)
>
> Thanks
> Jim Limburg
>
