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