281Re: [SQLQueriesNoCode] Re: selecting a multi-row result as part of a select
- Jul 3, 2003
> The way I understand your question the part of you query that iscorrect
> giving you problems in the subquery with the alias "Description" that
> is in you main SELECT statement. This subquery may return up to 6
> rows with scrtext_text for a given combination of ssbsect_subj_code,
> ssbsect_crse_numb, and scrtext_eff_term.
> Assuming, for dicussion purposes, that the subquery returns 6 rows,The latter is exactly what I'm after. And the text has to be ordered by the
> would you prefer
> 1. That the final result set have 6 rows, one for each of the rows
> returned by the subquery, or
> 2. That the final result set have 1 row, with the six values of
> scrtext_text concatenated into a single string?
sequence number, which may be a problem.
I may have to write a function that does this and select the function,
passing it course number and section.
- << Previous post in topic