Hola es que tengo esta otra consulta
Código PHP:
SELECT t.*, projects.project_name AS proyecto, CONCAT_WS(' ',contact_first_name,contact_last_name) AS creator
FROM task_log AS t, tasks, contacts
LEFT JOIN projects ON project_id = task_project
WHERE task_log_task = task_id AND task_status = 0
AND contact_id = task_log_creator
AND task_log_date >= '2007-10-16 00:00:00'
AND task_log_date <= '2007-10-30 23:59:59' ORDER BY task_log_date
y me saca el siguiente error
Unknown column 'task_project' in 'on clause'
por fa si alguien me puede colaborar... muchas gracias
