To add a WHERE clause to your query, you need drag the linking column from one table to the linking column in the other table (figure 1). The font of the column names will become bold.

The direction that you drag the link is relative to create the WHERE clause syntax. In the example below, if CustID from Customer T6 is dragged to Contact T5, the WHERE clause would look like: WHERE t6.custid=t5.custid. However, if CustID from Contact T5 is dragged to Customer T6, the WHERE clause would look like: WHERE t5.custid=t6.custid. This may be relevant in some cases.

image33
(figure 1)


To change the WHERE clause, you can delete the current link by right-clicking the linking line, and selecting Unlink from the speed-menu (figure 2).

image34
(figure 2)


To change the properties of the link, right-click the linking line, and select "Link options" from the speed-menu. You will then see the following dialog box (figure 3) for altering the WHERE condition:

image36
(figure 3)


For details on WHERE clauses and operators, see Commands: WHERE.

For details on Joins, see Commands: OUTER JOIN.