iEntry 10th Anniversary Webforumz RegistrationAnnouncements Contact Webforumz StaffContact
Home Resources Blogs Meet the Team Contact Register
 

Go Back   WebForumz.com > Putting it Together > Databases
Reload this Page Select from many tables!
Register All Albums Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
 
LinkBack Thread Tools
Old May 21st, 2007, 01:14 PM   #1
New Member
 

Join Date: May 2007
Location: bahrain
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Altering Power: 0 kool77 is on a distinguished road
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!
kool77 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Old May 22nd, 2007, 09:10 AM   #2
Reputable Member
 

Join Date: Jul 2005
Location: Melksham, Wilts, UK
Posts: 293
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Altering Power: 0 grahame is a jewel in the rough grahame is a jewel in the rough grahame is a jewel in the rough
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.
grahame is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Old May 30th, 2007, 04:09 PM   #3
New Member
 

Join Date: May 2007
Location: bahrain
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Altering Power: 0 kool77 is on a distinguished road
Re: Select from many tables!
Yes! That is exactly what I was looking for I didn't know what does it called .. Thank you my friend
kool77 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Bookmarks

Tags
columns , rows , select , tables

« Grant privileges | Converting Time »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
chained select box dependable select thenamenoonehastaken JavaScript 0 February 8th, 2008 01:49 AM
Help Please Select Max Not Working rosh1e PHP 3 May 13th, 2007 03:11 PM
CSS and select djme HTML, XHTML and CSS 1 March 1st, 2006 10:05 PM
Help with select statment rocket468 Classic ASP 4 December 8th, 2005 11:55 AM
Select a row and go! Please help? taymond JavaScript 1 November 16th, 2005 11:50 AM

WebForumz.com is an iEntry Network® publication - 1998-2009 All Rights Reserved Privacy Policy and Legal
Contact Us - Web Design and Web Development forums for Beginners to Advanced - Archive - Top

Search Engine Optimization by vBSEO 3.2.0 RC8