Hi All

I designed a database that most of the working tables have two ID fields becouse of replication purposal, for example Employee table have EMPLOYEEID, BROU_ID. Most of them have slave tables like PROJECTS table PROJEID,PROJE_SID(instead of BROU_ID),EMPLOYEEID,EMPLOYEE_SID(instead of BROU_ID)

Can I select two fields in a row indicating two fields on an other table two fields on masterlink?

Projects Employee
EMPLOYEEID EMPLOYEEID
EMPLOYEE_SID EMPLOYEE_SID

Thanks
Burak.


[Non-text portions of this message have been removed]