This is, however, a common case where standard SQL behavior can be very surprising and puzzling. I remember the first time this happened to me, and it took me a while to find my bug. (The problem was buried in a substantial amount of code.) Some people advocate always qualifying all column names for this reason. No, I don’t do that.