Each "Select" statement will over write the earlier one. i.e.

Select * from table_a into cursor mycursor

This will over write the cursor mycursor

Select * from table_b into cursor mycursor.

In fact I use this often to filter the data a second or third time.
John