In article <m23bmff78i(dot)fsf(at)Douglas-McNaughts-Powerbook(dot)local>,
Douglas McNaught <doug(at)mcnaught(dot)org> writes:
> Rory Browne <rory(dot)browne(at)gmail(dot)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 :-)