SELECT * FROM assignments
LEFT JOIN workers ON workers.id = assignments.id
LEFT JOIN positions ON positions.id = assignments.position
LEFT JOIN position_descriptions ON position_descriptions.id = positions.id
LEFT JOIN employers ON employers.id = positions.employerid
LEFT JOIN additonal_data ON additonal_data.id = assignments.id
**LEFT JOIN dates ON dates.id = assignments.id**
WHERE assignments.status = 3
**AND dates.work_length= 3**
**GROUP BY assignments.id**
ORDER BY assignments.id DESC
I only have 2 users in original query. Now when I added the dates table it started multiplying number of users by how many dates was there with dates.work_length = 3 so I grouped by assignments.id and it works good.
但现在列于表<编码>中。 <代码>work_length = 3 two (first on jan.01.2011, second on jul.01.2011), and with this query it Return the first day;我需要将最新日期Jul.01.2011.