Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
SELECT DISTINCT A.CARRIER_ID, A.EFFECTIVE, A.TRLR_TYPE_ID, A.CURRENT_NUM_VEHICLES FROM TL_RESOURCE_TRLR A, CARRIER_EQUIP B WHERE A.CARRIER_ID = B.CARRIER_ID(+) AND A.TRLR_TYPE_ID = B.TRLR_TYPE_ID(+) AND B.CARRIER_ID IS NULL -- EXCLUDE ROWS ADDED BECAUSE OF THE OUTER JOIN ORDER BY A.CARRIER_ID ASC;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.