Thursday, November 22, 2012  How to join three tables in SQL
query – MySQL Example  Three table JOIN Example SQL Joining
three tables in single SQL query can be very tricky if you are
not good with concept of SQL Join. SQL Joins have always been
tricky not only for new programmers but for many others,  who
are in programming and SQL for more than 2 to 3 years. There are
enough to confuse someone on SQL JOIN ranging from various types
of SQL JOIN like INNER and OUTER join, LEFT and RIGHT outer
join, CROSS join etc. Between all of these fundamentals, What is
most important about Join is, combining multiple tables. If you
need data from multiple tables in one SELECT query you need to
use either subquery or JOIN . Most of times we only join two
tables like Employee and Department but some time you may
require to join more than two tables and a popular case is
joining three tables in SQL. In case of joining three tables
table 1 relates to table 2 and than table 2 relates to table 3.
If you look at closely you find