Selecting Join Table Conditions
Starting with the first displayed child table name (table 2), select a parent field name from the drop-down list on the left of the equal sign, and select the child field name to be matched from the drop-down list on the right of the equal sign.
To add another condition to the list, change the drop-down at the right end from END to AND.
To remove an AND condition, change AND to END.