Re: [PHP-DB] Re: [PHP] Re: the opposite of a join?

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

 



left join where item in right table is null


>>> "Chris" <dmagick@xxxxxxxxx> 10/3/2007 10:32:01 PM >>>
Aleksandar Vojnovic wrote:
> I would also suggest to limit yourself to things you actually need not
> to select the whole table.

In this case you can't because you're looking for records that exist in
one table that don't exist in another.

Apart from looking at the whole table in each case how else would you do
that?

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux