Hello, Following is the query I’m using with multiple joins.
SELECT
`tickets`.`ID`, `tickets`.`ticketID`, `tickets`.`JobID`, `tickets`.`truck_number`, `tickets`.`material`, `tickets`.`asce_number`, `tickets`.`row_number`, `tickets`.`disposal_site` as site, `job_sites`.`name` as site, `tickets`.`disposal_date` as date, `tickets`.`work_number`, `tickets`.`type`, `jobs`.`ID`, `jobs`.`job_name`, `trucks`.`ID`, `trucks`.`contractor`, `contractors`.`company` as Contractor, `trucks`.`truck_capacity` as Capacity, `trucks`.`truck_license_plate`, `materials`.`ID`, `materials`.`type` AS material_type FROM (`tickets`)
JOIN `jobs` ON `jobs`.`ID` = `tickets`.`JobID`
JOIN `job_sites` ON `job_sites`.`ID` = `tickets`.`disposal_site`
[B]JOIN `contractors` ON `contractors`.`ID` = `trucks`.`contractor` [/B]
JOIN `trucks` ON `trucks`.`ID` = `tickets`.`truck_number`
JOIN `materials` ON `materials`.`ID` = `tickets`.`material`
problem is with "JOIN contractors
ON contractors
.ID
= trucks
.contractor
"
It says #1054 - Unknown column ‘trucks.contractor’ in ‘on clause’