Re: Re: the opposite of a join?
| From: | Aleksandar Vojnovic | Date: | Thu, 04 Oct 2007 05:39:02 +0000 |
| Subject: | Re: Re: the opposite of a join? | ||
| References: | 1 2 3 4 5 6 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-44139@lists.php.net to get a copy of this message | ||
It seems you missed my point :) if you would need all the data then select them all, but if you need only partial data from the table then you could limit yourself to that specific columns. I doubt everybody need everything all the time. True?
Aleksandar
Chris wrote:
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?