Re: Disappearing Records

In article <m23bmff78i.fsf@Douglas-McNaughts-Powerbook.local>,
Douglas McNaught <doug@mcnaught.org> writes:

> Rory Browne <rory.browne@gmail.com> writes:
>> select u.username, g.groupname from users u, groups g where u.group_id=g.id
>> (assuming users are in exactly one group)
>>
>> If the group_id field in the users table was corrupted, and set to a
>> value that isn't in the groups table, then that view wouldn't return
>> anything.

> That's why foreign key constraints are good.  :)

Well, Rory already confessed that he came from a MySQL background :-)