My database has a table listing employee details which links to a table of documents. Another table lists document versions which links to a table of document version owners.
Since most of the people in the employees table are also in the document owners table any alterations to their details need to be updated twice.
Can anyone tell me how to use a table twice in one database? All attempts to date have resulted in “ambiguous outer joins”.
Regards
Tyler
Since most of the people in the employees table are also in the document owners table any alterations to their details need to be updated twice.
Can anyone tell me how to use a table twice in one database? All attempts to date have resulted in “ambiguous outer joins”.
Regards
Tyler