Re: SELECT FROM 2 or more tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



You rarely want to do a join with no filters is what i was trying to get at.

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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux