select rows from more than one table, how?
| From: | Sander Peters | Date: | Mon, 11 Mar 2002 21:02:57 +0000 |
| Subject: | select rows from more than one table, how? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17609@lists.php.net to get a copy of this message | ||
Hello,
I want to make a query that will select rows from more than one query,
does anybody know how to do that?
I already tried this:
SELECT * FROM table1, table2 WHERE (conditions)
But I get a error with this query.
I also looked at the mysql site for this case, but I didn't find any
answer (I guess it's there but I just can't find it!)
Can somebody help me?
Thanks in advance!
--
Met vriendelijke groet / With Greetings,
Sander Peters
site: http://www.visionnet.nl/
email: mailto:s.peters@visionnet.nl
webmail: mailto:sanderpeters@yahoo.com