MySQL Left Join

[Jul 18, 2010]

When saving data from dropdown list into database. We could create another table that store the dropdown list information, and link its ID to table that store the selected dropdown item.

We can use MySQL Left Join to search if the user has selected the dropdown item with specific name.

SELECT * FROM t1 LEFT JOIN (t2, t3, t4)
ON (t2.a=t1.a AND t3.b=t1.b AND t4.c=t1.c)

http://dev.mysql.com/doc/refman/5.0/en/join.html