Criteria as Column

The "Column" tab allows you to specify directly a column name to be used with the chosen operator for the concerned field. For example you can compare the DEBIT field from one table with the CREDIT field from another table: the criteria will be something like T1.DEBIT >= T2.CREDIT. That column name can be entered manually or automatically using the right Combo-box button. That button will display the existing column names from all the tables selected in that query.

See also:

Defining criteria

Criteria as Expression

Criteria as Query

Criteria as Value