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. :)
-Doug