Thank you.
On Wed, 21 Jan 2009, c...@l-i-e.com wrote:
The natural join will JOIN on *all* the fields whose names match, not just the
ones you want it to.
In particular, the JOIN is matching up .expires and .expires with "="
You then use WHERE to get only the ones with ">"
This is a tautolo
The natural join will JOIN on *all* the fields whose names match, not just the
ones you want it to.
In particular, the JOIN is matching up .expires and .expires with "="
You then use WHERE to get only the ones with ">"
This is a tautology: There are NO records both "=" and ">" on the fie
I am comparing two tables, domains and temp, to find records with a field that
has been modified. I create the temp table with
create table temp like domains;
then [eventually] create a table t3 that contains the domain name of any record
that does not match. My question is about 'natural j
