publication Properties, Filter Rows Tab (merge publication)
The following options are available on the Filter Rows tab of the publication Properties dialog box.
Options
Owner
View the name of the owner of the table.
Table
View the name of the table on which the article is based.
Article
View the name of the article.
Filter clause
View the clause used to filter the rows included in the article.
(...)
Enter or modify the filter clause.
Filtered table
Select the name of the filtered table. Only tables that either have a row filtered or are filtered through a JOIN are displayed in this column. Select Delete JOIN to remove an existing JOIN.
Table to filter
Select the name of the table to which filtering is extended.
Join filter clause
View the JOIN clause used to extend the filtering from Filtered table to Table to filter.
(...)
Enter or modify the JOIN clause.