New answers tagged


There are several problems with the query The select list is missing. The join syntax needs ON, not WITH: a JOIN b ON <some condition> There is a missing on condition (what you correctly identified as arbitrary/random join between Contractor and ContractorJob). There are column names mismatches between the code and the design: (Job.contractor_job ...

Top 50 recent answers are included