use more than two tables

Expand Post »

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

Similar Threads

updating 2 HTML tables on one PHP page in PHP
web design: tables versus divs in HTML and CSS
Layout Tables to CSS in HTML and CSS
Large and tables/cells..how? in HTML and CSS
Internal Data Tables in Visual Basic 4 / 5 / 6

lydia21

Reputation Points: 19

Solved Threads: 5

Junior Poster

Offline

183 posts
since Nov 2007

Permalink

Jul 25th, 2008

Re: use more than two tables

you can use joins for this:

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

Shanti C

Reputation Points: 137

Solved Threads: 162

Posting Virtuoso

Offline

1,641 posts
since Jul 2008

Permalink

Jul 25th, 2008

Re: use more than two tables

thanks.i tried this way

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

lydia21

Reputation Points: 19

Solved Threads: 5

Junior Poster

Offline

183 posts
since Nov 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: Query...errr...query

Next Thread in MySQL Forum Timeline: Mysql IsNull check

DaniWeb Message

Cancel Changes

User Name
Password