RE: [PHP-DB] SELECT FROM 2 or more tables
| From: | Ben Lake | Date: | Wed, 20 Aug 2003 20:20:39 +0000 |
| Subject: | RE: [PHP-DB] SELECT FROM 2 or more tables | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30001@lists.php.net to get a copy of this message | ||
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: [PHP-DB] 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