MySQL

use more than two tables

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Nov 2007

Posts: 183

Reputation: lydia21 is an unknown quantity at this point

Solved Threads: 5

lydia21

Offline

Junior Poster

use more than two tables

Jul 25th, 2008

hi,
i want to select from more than two table using a single mysql query.please tell me a example query/.
thanks in advance

•

Join Date: Jul 2008

Posts: 1,076

Reputation: Shanti Chepuru is on a distinguished road

Solved Threads: 98

Shanti Chepuru Shanti Chepuru is offline

Offline

Veteran Poster

Re: use more than two tables

Jul 25th, 2008

you can use joins for this:

Help with Code Tags

my sql Syntax (Toggle Plain Text)

"select * from table1 as t1,table2 as t2 where ti.id=t2.id";

this is simple....
Have look on this url follows:
http://www.tizag.com/mysqlTutorial/mysqljoins.php

Be intelligent, But Don't try to cheat.. Be innocent But Don't get cheated..

•

Join Date: Nov 2007

Posts: 183

Reputation: lydia21 is an unknown quantity at this point

Solved Threads: 5

lydia21

Offline

Junior Poster

Re: use more than two tables

Jul 25th, 2008

thanks.i tried this way

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
SELECT article.id,article.ar_title,article.owner,article.ar_date,addinfo.pat,login.username
FROM article
LEFT JOIN (
login,addinfo
) ON ( login.id = article.owner
AND login.id = addinfo.userid
AND article.owner = addinfo.userid ) 
WHERE article.owner =17
LIMIT 0 , 30 ORDER BY article.ar_date DESC
SELECT article.id,article.ar_title,article.owner,article.ar_date,addinfo.pat,login.username
FROM article
LEFT JOIN (
login,addinfo
) ON ( login.id = article.owner
AND login.id = addinfo.userid
AND article.owner = addinfo.userid ) 
WHERE article.owner =17
LIMIT 0 , 30 order by article.ar_date DESC