OK amigo:
Código SQL:
Ver originalSELECT e.cal_id,e.cal_cliente, CONCAT(cl.cal_nombre1,' ',cl.cal_apellido1,' ',cl.cal_apellido2)
AS cal_cliente_nombre,e.cal_empresa,c.cal_nombre
AS cal_empresa_nombre,e.cal_estado,e.cal_create_by,CONCAT(u.cal_lastname,' ', u.cal_firstname)
AS cal_creador,e.cal_date,e.cal_time,e.cal_name,e.cal_location,e.cal_description,
ce.cal_entry AS calcal_close_entry
FROM webcal_entry e
INNER JOIN webcal_user u ON u.cal_login = e.cal_create_by
LEFT JOIN webcal_company c ON c.cal_company_id = e.cal_empresa
LEFT JOIN webcal_client cl ON cl.id_cliente = e.cal_cliente
LEFT JOIN webcal_close_entry ce ON e.cal_id = ce.cal_entry
WHERE e.cal_id = 300
GROUP BY(calcal_close_entry )