In the table definitions you've given there is no ContractorID, however, it's used in your joins. I can't recreate your tables/query if you're not providing the correct information to do so. Without the correct information it forces me to make assumptions.