Aha. Well, you learn something new every day. Yes, the behavior is
indeed like "contact_id is not null", which was true for all rows in
users, which explains why I lost all my data in realtycompany_contacts.
Thank goodness for backups. Many thanks!
James
On Jul 1, 2004, at 3:35 PM, Stephan Szabo wrote:
> AFAIK the spec requires that subselects like that can reference outer
> columns so contact_id inside the subselect refers to the outer
> contact_id
> column which does exist (which makes the effective behavior of the
> above
> clause the same as contact_id is not null I think)
>
----
James Robinson
Socialserve.com