John A DAVIS wrote:
left join where item in right table is null
That's still going to look at all records in both tables:
1) so it can work out if there is a match from table 1 to table 2
2) so it can then remember to display any records that don't have a match
I was thinking more that if you
left join where item in right table is null
>>> "Chris" <[EMAIL PROTECTED]> 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 e
Aleksandar Vojnovic wrote:
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?
Ahh - you meant the se
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 wrot
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 e
5 matches
Mail list logo