if would be an outer join, an inner join would give an empty record set. I don't know either as I use outer joins in SQL, but haven't needed them in Crystal so I don't know which table is on the left.
The more I think about it, the more I am drawn to a select statement like:
select e.employee, s.employee AS employeeS from employee as e left join supervisor s on s.employee = e.employee
if s.employee is NULL, then the record is not in the supervisor table, if it has a value, it is there. There is a possiblity of multiple records this way if the employee has more than 1 record in the supervisor table.
HTH
IP Logged
