On Wednesday, August 20, 2003, at 04:20 PM, Ben Lake wrote:
Rarely want to do joins? That's a new one.
Ben
-----Original Message----- From: Brent Baisley [mailto:brent@landover.com] Sent: Wednesday, August 20, 2003 3:04 PM To: John Ryan Cc: php-db@lists.php.net Subject: Re: SELECT FROM 2 or more tables
A join merges every record in one table with every record in another table, which is something you rarely want to do. So you want to set a filter on the merged records, which can be anything, but is usually a match between a field in one table and a field in another table.
That's a join in two sentences or less.
On Wednesday, August 20, 2003, at 03:41 PM, John Ryan wrote:
I cant grasp JOIN for the life of me
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
