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, MAX (A.EFFECTIVE), A.TRLR_TYPE_ID, A.CURRENT_NUM_VEHICLES, L.NAME FROM TL_RESOURCE_TRLR A, CARRIER_EQUIP B,LANE L WHERE A.CARRIER_ID = B.CARRIER_ID(+) AND A.TRLR_TYPE_ID = B.TRLR_TYPE_ID(+) AND A.LANE_ID = L.ID AND B.CARRIER_ID IS NULL -- EXCLUDE ROWS ADDED BECAUSE OF THE OUTER JOIN GROUP BY a.carrier_id, a.trlr_type_id, current_num_vehicles, L.NAME ORDER BY A.CARRIER_ID ASC;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Need to Understand Resolution to Oracle Error ORA-00600||2||51|
|T-SQL: problem comparing datetime||4||73|
|Please explain the difference between EXCLUDE, INTERSECT and JOIN||7||46|
Join the community of 500,000 technology professionals and ask your questions.