RE: [PHP-DB] select rows from more than one table, how?
| From: | Rick Emery | Date: | Mon, 11 Mar 2002 20:52:27 +0000 |
| Subject: | RE: [PHP-DB] select rows from more than one table, how? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17610@lists.php.net to get a copy of this message | ||
First: show us your exact query
Second: show us your exact error response
Third: show us your exact code and table structure
-----Original Message-----
From: Sander Peters [mailto:S.Peters@Visionnet.nl]
Sent: Monday, March 11, 2002 3:03 PM
To: php-db@lists.php.net
Subject: [PHP-DB] select rows from more than one table, how?
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php