I think i'm missing one join somewhere cause i dont have any error and i done have any records also.
I think i have to also use this: AND TR.LANE_ID=R.ID
Wilder1626
ASKER
I worked the code.
Let me test like this
SELECT * FROM TL_RATE WHERE NOT (TL_RATE.RATE_KEY IN (SELECT LOAD.RATE_KEY FROM LOAD) AND NOT (TL_RATE.LANE_ID IN (SELECT LANE_RATE_NETWORK.ID FROM LANE_RATE_NETWORK))) AND TL_RATE.DATE_INVALID > TO_DATE (TO_CHAR (SYSDATE, 'YYYYMMDD'), 'YYYYMMDD');
I think i'm missing one join somewhere cause i dont have any error and i done have any records also.
I think i have to also use this: AND TR.LANE_ID=R.ID