Jeff, This works perfectly. The LEFT JOIN did the trick. I'm investigating this as part of my quest for knowledge. Thanks!

Hmm, this is what I have, and whilst it doesn't crash with any syntax errors, it produces nothing. Currently, the requests table has no drivers, but I still need it...

Thanks for this. It confirms my googling explroations, and I'm about to try it.

I wonder what will happen on those requests where a driver hasn't yet been allocated. They still...