Rory Browne <rory.browne@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
