Hi,
I didn't bother analysing this too deeply, so keep that in mind when you
read my reply ;-)
However the point that set off alarm bells for me was this statement "we now
have an over-ride table".
It seems to me that you shouldn't be over-riding anything, and the emp_dept
table should just be
Doug Y a écrit :
I can't figure out an efficient way to do this. Basically I had a
typical 3-tier relationship:
(Employee -> Department -> Division)
However, at some point the need to move employees arose, but instead
of changing the key in the emp table, we now have an over-ride table,
so a his
