Page 1 of 1

Displaying data from more than one table

Posted: Wed Feb 22, 2006 8:55 am
by aceconcepts
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

Posted: Wed Feb 22, 2006 9:16 am
by chrys
Do you want to display the data in one table, or you want to receive the data as one result? What's your goal

Posted: Wed Feb 22, 2006 10:32 am
by aceconcepts
I would like to display the data in one table.

I am able to display rows of data from one MySql table but i do not know what suntax to use in order to retrieve data from more than one table.

Posted: Wed Feb 22, 2006 10:42 am
by feyd