Re: question about natural join

2009-01-21 Thread doug
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

Re: question about natural join

2009-01-21 Thread ceo
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