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?

amphetamachine · Accepted Answer · 2010-06-02 02:38:11Z

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);

answered Jun 2, 2010 at 2:38

amphetamachine

30.9k12 gold badges68 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Your answer is correct but the results are only from logout table. I wanted to have a result that coming from the two tables.

Oh. I think thats not join tables. I found an answer using UNION. Thanks a lot in your answer. It helps me a lot. Thank you.