Question

$sql = "SELECT logs.full_name, logout.status FROM logs, logout WHERE logs.employee_id = logout.employee_id";

tables --> logs
           logout

www.un.org/Depts/DGACM/index_spanish.htm 我对此有错误。我的搜索与表一样。这也是我所说的话。该法典有什么错误?

Answer 1

在你的询问中,我看不到“JOIN”。

正确的辛迪加:

SELECT logs.full_name, logout.status FROM logs
    LEFT JOIN logout ON (logs.employee_id = logout.employee_id);