writing a query

[shamrox]

I have a web page that I want to display alot of info on from several different tables. they will all be linked by various "id's" back to the main table.

I'm not really sure how to get it all to display. I assume I need to do LEFT JOINS on the main table, but where do i go from there?

I hope this wasn't to vague. thanks for your help.

http://www.metrodesignworks.com

http://www.nowthatsodd.com/deadpool/

 

[ggggus]

could you give an example?

LEFT JOIN is usually used for pulling information that may or may not be there into the same table, not for seperate tables.

I'm assuming you'll probably need to do several queries, one for every table, and use the common id in the queries.

***************************************
J. Jacobs

http://www.piercedmedia.com

 

[cLFlaVA]

The way you would get this data to display is by utilizing your scripting language's functions.

PHP and ASP have many different functions for connecting to a MySQL database, querying the database, and then printing out the data.

*cLFlaVA
----------------------------
A pirate walks into a bar with a huge ship's steering wheel down his pants.
The bartender asks, "Are you aware that you have a steering wheel down your pants?"
The pirate replies, "Arrrrr! It's driving me nuts!