Joining Tables

[JS=Freak]

Can someone please help me? I have five tables with several fields each and values stored within the fields. I want to have a page that displays a list with values taken from one field in each table. How do I join fields from different tables together and display it in one list? I'm assuming a while loop would be needed to display all fields in the table but how do I throw it all together?


Thanks,
Karen

[s.b37]

you do mean a table in a mysql db right?

you can do this all within your sql query

im not sure what you want exactly, but you can get more information on selecting from multiple tables, joins and unions at http://www.w3schools.com/sql/sql_join.asp

if you post more information (what type of information, etc) i can give you more details