在WHERE子句中,表别名为
`O.firstname`
这是错误的方法,您可以对列名应用倒勾,而不是使用表别名,它应该是
O.`firstname`
如果你申请
LEFT JOIN
中的相关条件
左连接
本身,而不是
WHERE
如果在
employees
桌子:
所以问题是:
SELECT V.*,
CONCAT(O.firstname, ' ', O.lastname) AS ownerName,
CONCAT(A.firstname, ' ', A.lastname) AS assigneeName
FROM vehicles AS V
LEFT JOIN employees AS O ON V.owner = O.id AND (A.`firstname` LIKE '%xyz%' OR A.`lastname` LIKE '%xyz%')
LEFT JOIN employees AS A ON V.assigned_to = A.id AND (V.`license_state` LIKE '%xyz%' OR V.`make` LIKE '%xyz%' OR V.`model` LIKE '%xyz%')
WHERE O.`firstname` LIKE '%xyz%' OR O.`lastname` LIKE '%xyz%'