Page History

...

The following xml fragment defines a where clauses on the employees table that excludes records with emp_id = 3. The where clause is set for both the left and the right databaseschema:

<TablePairs>
     <Pair>
          <LeftObject Name="dboHR.employeesEMPLOYEES"/>
          <RightObject Name="dboHR_COPY.employeesEMPLOYEES"/>
          <WhereClause>emp<WhereClause>EMPLOYEE_id ID != 3</WhereClause>
     </Pair>
</TablePairs>

The following xml fragment defines separate where clauses on the employees table for the left and the right databaseschema. On the left databaseschema, it excludes records with empEMPLOYEE_id ID = 3; on the right databaseschema, it excludes records with empEMPLOYEE_id ID = 4.

<TablePairs>
     <Pair>
          <LeftObject Name="dboHR.employeesEMPLOYEES"/>
          <RightObject Name="dboHR_COPY.employeesEMPLOYEES"/>
          <LeftWhereClause>emp<LeftWhereClause>EMPLOYEE_id ID != 3</LeftWhereClause>
          <RightWhereClause>emp<RightWhereClause>EMPLOYEE_id ID != 4</RightWhereClause>
     </Pair>
</TablePairs>

...

...