Join 2nd table to 1st where only 2nd table is empty.

[gene7135]

I hope somebody can help. I only want results where table TIMMAN_JOB_TRANS returns No Rows.

SELECT A.ORDER_NO, A.SERIAL_BEGIN, A.HVR_SUBSTITUTE_SERIAL, A.PART_NO, A.HVR_SUBSTITUTE_PART, A.STATEFROM SHOP_ORD A       INNER JOIN TIMMAN_JOB_TRANS F ON F.COL1_DESC LIKE (A.ORDER_NO || '%')             WHERE A.CONTRACT = '640' AND A.STATE = 'Started' AND ROWNUM < 10 ORDER BY B.LAST_ACTIVITY_DATE