Forum : What does this query mean: SELECT user_name, user_isp FROM users LEFT JOIN isps USING (user_id) ?
Brief description about Online courses   join in Online courses
Home News Viewpoint
Travel Entertainment Auto Gadgets & Electronics Sports Lifestyle Food
Rankings Whitepapers Blogs Conferences About Us
View Abhijit Paul 's Profile

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

What does this query mean: SELECT user_name, user_isp FROM users LEFT JOIN isps USING (user_id) ?
Asked by Abhijit Paul | Mar 18, 2010 |  Reply now
Replies (1)
View teacher siliconindia 's Profile
Hi Abhijit,
It's equivalent to saying SELECT user_name, user_isp FROM users LEFT JOIN isps WHERE users.user_id=isps.user_id
Mar 18, 2010

Forum By Category