use more than two tables

[lydia21]

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

[Shanti C]

you can use joins for this:

"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

[lydia21]

thanks.i tried this way

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