How to Join three table together in MySQL. Left Join Maddness!!!

Mar 1 2011 by Andrew Brown

The Problem

I’m building a web-app with groups. There are a bunch of links in the group, and you can star, comment thumb them up. Then there is a page that shows who has starred, commented and thumbed things. Basically like digg or reddit.

So that means I need to join three tables together:

group_shared_links
shared_links
links

It may sound dumb but I didn’t learn how to use join’s recently. Never had to, so if your in the same boat that I was in, I hope I can save you time learning how to do this with my example.

Comp dead, new one coming in at end of week, this article will be finished first week of March

Write a Comment to “How to Join three table together in MySQL. Left Join Maddness!!!”