Page History

A where clause is an SQL expression that is used as a data filter. Only the records that meet the where clause criteria are compared and synchronized. You can specify any valid SQL expression as the where clause. The "where" keyword should not be included in the expression.

...

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>

...

...