0

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

2
Contributors
2
Replies
3
Views
9 Years
Discussion Span
Last Post by lydia21
0

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
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.