Displaying data from more than one table
Posted: Wed Feb 22, 2006 8:55 am
Hi,
I have three MySql tables 'Client', 'Product' and 'Product_Order'.
I would like to be able to display all information from each MySQL table in an html.
What is the MySql 'SELECT' syntax i use in order to make this happen?
Relationships already exist between the three tables.
Nick
I have three MySql tables 'Client', 'Product' and 'Product_Order'.
I would like to be able to display all information from each MySQL table in an html.
What is the MySql 'SELECT' syntax i use in order to make this happen?
Relationships already exist between the three tables.
Nick