first off please read this
https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
then post back with the necessary script that allows us to easily set on our own systems.
suggest that you also post some more sample data....that includes truck runs where you arent going to get results (that way we can be sure our code works)
are there only ever two drivers per truck run?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day