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