>>Try
>>

>>SELECT ctrl, item FROM table1 WHERE cust_name='JONES' ;
>>UNION ALL
>>SELECT ctrl, item FROM table2 WHERE cust_name='JONES' ;
>>INTO CURSOR crsResult
>>

>
>Yes thanks, this worked. but in the examples on the net, it doesn't explain this method(that I could find).

As you can see, a query with UNION allows to combine SELECTs from 2 or more tables into one resultset.