Page 1 of 1

Joins

Posted: Wed Oct 28, 2009 11:29 am
by jamferoza
How to join three table in php mysql?

Re: Joins

Posted: Wed Oct 28, 2009 1:19 pm
by ipconfig
You can practically join as many tables as you want!
For example:

Code: Select all

SELECT column_name(s) FROM table_name1
INNER JOIN table_name2 ON table_name1.column_name=table_name2.column_name
INNER JOIN table_name3 ON table_name2.column_name=table_name3.column_name
Have a look at this page:
http://www.w3schools.com/Sql/sql_join.asp