mySQL relations query

From: 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

« previous php.general (#122925) next »