Re: MySQL syntax

[Phillip Ward]

That "Details..." item at the end looks "interesting". Did you look to see what it told you?

I'd guess that either employee.branch_id and branch.branch_id are different Data Types or branch_id is not the primary key on the branch table. (Or, perhaps, the field may not be indexed).

Without knowing the structure of your tables, it's impossible to say for certain, so ...
Show us the output of "SHOW CREATE TABLE X \g" for both tables.

Regards, Phill W.