Re: Inner Join of 3 tables

[douglas wilson]

Inner join can use to joining the tables.you can join many table.This is the syntax of the inner join.Do not use union.Just try this queries.

SELECT column_list FROM t1 INNER JOIN t2 ON join_condition1 INNER JOIN t3 ON join_condition2
...
WHERE where_conditions;

SELECT t1.col, t3.col FROM table1 join table2 ON table1.primarykey = table2.foreignkey
join table3 ON table2.primarykey = table3.foreignkey

and this is the eg:

mysql> SELECT emp_name, dept_name FROM Employee e JOIN Register r ON e.emp_id=r.emp_id JOIN Department d ON r.dept_id=d.dept_id;