SELECT * FROM table1 ; WHERE ; field1 = ( SELECT ... ) ; AND field2 = ( SELECT ... ) ; ... AND field9 = ( SELECT ... ) ; INTO CURSOR myCursor