PHP MySQL join table

Question

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

tables --> logs
           logout

I'm having error on this. I search join tables in google. And that's what I got. What is wrong with this code?

Answer 1

Here is a nice little visual explanation of SQL Joins in general. I hope it will help you as much as it helped me.

Answer 2

I don't see a "JOIN" anywhere in your query.

The correct syntax:

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