RE: [PHP-DB] SELECT FROM 2 or more tables

Hehe, ok, that was bad there for a second :) Ben -----Original Message----- From: Brian Dailey [mailto:bdailey@hypersoft.net] Sent: Wednesday, August 20, 2003 3:24 PM To: Ben Lake; php-db@lists.php.net Subject: Re: [PHP-DB] SELECT FROM 2 or more tables 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: > > >>I cant grasp JOIN for the life of me >> -- - Brian Dailey - HyperSoft Support - http://www.hypersoft.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php