On Sat, 11 Aug 2001 16:57:10 +0000 (UTC), <lockhart@fourpalms.org>:
> Perhaps not a helpful one... but I would be inclined to reorganize that
> third table to have a "start date" *and* a "stop date" field, and ditch
> the "dropped" boolean:
>
This is how I would do it, then query for employees with
records that have NULL in the "stop date" field.