Re: In JOIN, what happens two of the same id name appears?

[Jon Stephens]

That's correct. It IS misleading to speak of selecting accounts.name from web_events, because that's NOT what the query does.

The query selects from a set of rows that come from the web_events table AND the accounts table.

SELECT columns 

FROM 

(web_events JOIN accounts ON condition)

The part that I've put inside parentheses is what the query selects from.

cheers,

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle