Jump to content

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


gene7135
 Share

Recommended Posts

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...