Oracle - Query where no result in a table

Hi

I'm trying to query all carriers where CARRIER_ID, LANE_ID and TL_RESOURCE_ID from table TL_RESOURCE_CARRIER will not show in table  TL_RESOURCE_TRLR.

In the below query, i pulls records where it does show a record in both tables.

In the attachment, you will see the 3 tables and what should be the final result for the query needed.

Thanks for your help.

SELECT DISTINCT TRC.CARRIER_ID,
  TRC.LANE_ID,
  L.NAME
FROM LANE L,
  TL_RESOURCE_CARRIER TRC,
  TL_RESOURCE_TRLR TRT
WHERE TRT.LANE_ID           = L.ID (+)
AND TRC.LANE_ID             = TRT.LANE_ID (+)
AND TRC.CARRIER_ID NOT     IN TRT.CARRIER_ID
AND TRC.TL_RESOURCE_ID NOT IN TRT.TL_RESOURCE_ID
AND TRC.LANE_ID             = L.ID
ORDER BY TRC.CARRIER_ID;

Select all Open in new window

tl-resources-carrier-table.xlsx