What does this query mean: SELECT user_name, user_isp FROM users LEFT JOIN isps USING (user_id)

Question

Hello
What does this query mean: SELECT user_name, user_isp FROM users LEFT JOIN isps USING (user_id)
please reply me. i am waiting for your reply.
Thanx

Answer 1

It’s equivalent to saying SELECT user_name, user_isp FROM users LEFT JOIN isps WHERE users.user_id=isps.user_id