Conditional statements are used in both the FROM and WHERE clauses. The most common operator is the equals ‘=’ sign however there are others that can be used as well. There are a few types of conditional statements. The first is the normal logical group of equals ‘=’, not equals ‘<>’ or ‘!=’, less than ‘<’, greater than ‘>’, less than or equal to ‘<=’, and greater than or equal to ‘>=’. These statements are similar to those found in programming languages or applications such as Excel.
|=||field1 = field2||field1 must equal field2|
|<> or !=||field1 <> field2||field1 must not equal field2|
|>||field1 > field2||field1 is greater than field2|
|>=||field1 >= field2||field1 is greater than or equal to field2|
|<||field1 < field2||field1 is less than field2|
|<=||field1 <= field2||field1 is less than or equal to field2|