This is a discussion on "Select from many tables!" within the Databases section. This forum, and the thread "Select from many tables! are both part of the Program Your Website category.
|
|
|
|
|
 |
||
Select from many tables!
|
||
| Notices |
 |
|
|
LinkBack | Thread Tools |
|
#1
May 21st, 2007, 17:14
|
|||
|
|||
|
Select from many tables!
Hi
I want to know what is the statement that select a column from table1 and a column from table2 and column from table3.. etc to show them all with a new column that calculates the average of each row. I don't know how to do that  help please!       
|
|
|
|
#2
May 22nd, 2007, 13:10
|
|||
|
|||
|
Re: Select from many tables!
You need to JOIN your table together, telling MySQL how the tables should be linked to each other. A Google search for "MySQL Left Join" will bring you to a number of resources (including mine
 ) which included more detailed examples.
|
|
| Tags |
| columns, rows, select, tables |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| chained select box dependable select | thenamenoonehastaken | JavaScript Forum | 0 | Feb 8th, 2008 05:49 |
| Help Please Select Max Not Working | rosh1e | PHP Forum | 3 | May 13th, 2007 19:11 |
| CSS and select | djme | Web Page Design | 1 | Mar 2nd, 2006 02:05 |
| Help with select statment | rocket468 | Classic ASP | 4 | Dec 8th, 2005 15:55 |
| Select a row and go! Please help? | taymond | JavaScript Forum | 1 | Nov 16th, 2005 15:50 |
