So I have a table with ids that start with a letter to denote which table ID they're related to, i.e. D86 means they're in the `division` table with id 86, and L86 means they're in the `lab` table with id 86. 

So I was wondering if it was possible to do something like `col like 'D%' left join div on ...` and use `lab` for the other one.