Hi Sheena,
SELECT cs.sin ;
FROM coun_sum, act_plan ap ;
WHERE cs.sin = ap.sin ;
AND !EMPTY(ap.follow_dte) ;
AND cs.sin IN (SELECT clients.sins FROM clients) ;
ORDER BY cs.sin ;
INTO cursor test
>Hello:
>
>I'm trying to pull information into a report based on conditions
>from 3 tables using select statements. I'm storing this in a cursor that then will produce my report. My problem is that I want the results of the first select statement, that uses two tables, put in a cursor and then get the these results to match and ultimately print the information from my main table. Can I append from one cursor to another to do this or is there an easier way. My code is as follows:
>
>select cs.sin from coun_sum, act_plan ap where cs.sin = ap.sin;
>and !empty(ap.follow_dte) order by cs.sin into cursor test
>
>I want these cs.sins to match my client.sins from my client table and print the client information into a report.
>
>
>So I need another select statement based on the result of the first select statement. i.e. , if I get 10 sin numbers from my select statement I want the matched sin in the client table to print to my report.
>
> Any help would be greatly appreciated.