On Jan 31, 2004, at 3:35 PM, Anony Mous wrote:
Actually, given that there may not always be a backup_employee field (can be
null) I think I'm forced to use an outer join to return all team leader
records regardless if a matching backup_employee record exists.
yup. Actually, I hadn't seen the other responses when I first posted. You've got some options, it looks like. :)
Michael Glaesemann
grzm myrealbox com
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
