Well, if both tables are in the same database:

select * from books inner join publishers on books.publisherid = 

this assumes that the key for the publisher is publisherid and that 
publisherid also appears in the book table.

This gives you a result set that contains the appropriate information from 
both tables merged.


php|architect -- The Monthly Magazine For PHP Professionals
Visit us on the web at http://www.phparch.com!

On Wed, 6 Nov 2002, Edgard 
Berendsen wrote:

> 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

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to