mySQL relations query
| From: | Edgard Berendsen | Date: | Wed, 06 Nov 2002 03:42:52 +0000 |
| Subject: | mySQL relations query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-122925@lists.php.net to get a copy of this message | ||
I know this can be a little out of topic but:
I have a books database and each book belongs to a publisher.
There is also a publisher database with information like (name,
location, etc). In the books database there is a key to identify the
publisher.
I need a mySQL query for showing each book with each publisher
name and location.
I don't want to do it using nested loops in .php because I think that
using a "master" SQL query that can access both tables (all inside mySQL)
and their relations can be much faster.
Thanks