Gene Wirchenko wrote:
> "Tony Andrews" <andrewst_at_onetel.com> wrote:
> >Foreign key constraints implement a subset of
> >possible multi-table rules, e.g. "employee.deptno must correspond to
a
> >department.deptno", but not all conceivable constraints, e.g.
> >"employee.deptno must correspond to a department.deptno where
> >employee.hiredate between department.open_date and
> >department.close_date".
>
> All employees for a new department must be newly-hired?
Whatever - it was just to illustrate a complex constraint; maybe I
could have done better with more thought.
Received on Tue Oct 19 2004 - 11:01:16 CDT
