Re: SELECT FROM 2 or more tables
| From: | Brian Dailey | Date: | Wed, 20 Aug 2003 20:24:06 +0000 |
| Subject: | Re: SELECT FROM 2 or more tables | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30002@lists.php.net to get a copy of this message | ||
No, he meant rarely want to join entire tables without a cross referencing ID column.
That's definitely something you wouldn't want to do very often. It's impractical and extremely inefficient.
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: [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:-- - Brian Dailey - HyperSoft Support - http://www.hypersoft.netI cant grasp JOIN for the life of me