Your second SELECT isn't specifying any fields from cursor1 in the field list (ex. cursor1.*).
HTH
Dan
>I have a cursor1 that contains some vehicle service results, when I try to join it with my second cursor2, the results don't seem to show from cursor1 in cursor2. Cursor2 only seems to show the information from vehicle and not the information from cursor1. I know I am missing something simple here.
>
>
> SELECT s_id, MAX(s_curr_mile), MAX(s_invdate) FROM services_tbl ;
> GROUP BY s_id ;
> WHERE s_serv_type == ALLTRIM(.c7.value) INTO CURSOR cursor1
> BROWSE
> SELECT v_id, v_sup, v_no, v_vin , v_mileage , v_model , v_style ;
> FROM vehicle ;
> right JOIN cursor1 ON vehicle.v_id = cursor1.s_id ;
> INTO CURSOR cursor2
>Thanks
>Nick Patel