(S.CUSTOMERS.ZIP > 94400 AND S.CUSTOMERS.TOT > 1000) | A row must match both of these conditions to be retrieved by the query. In this example, returns all customers with zip codes over 94400 and order totals over $1000. |
(S.ORDERS.INVOICE_DATE IS NULL EQV S.ORDERS.PAID_IN_FULL = 'Y') | The query retrieves the row if both conditions are true or if both conditions are false. In this example, returns customers who have unshipped orders paid in full and customers who have shipped orders, still unpaid. F EQV F = T F EQV T = F T EQV F = FT EQV T = T |
(S.ORDERS.INVOICE_DATE IS NULL IMP S.ORDERS.PAID_IN_FULL = 'Y') | The query retrieves the row if one condition implies the other; that is, if the premise is false, of if both the premise and the conclusion are true. In this example, returns names of customers who have shipped orders, paid or unpaid, and customers who have shipped orders, still unpaid. F IMP F = T F IMP T = T T IMP F = F T IMP T = T |
NOT (S.ORDERS.PAID_IN_FULL = 'Y') | The query retrieves the row if it does not match this condition. In this example, returns names of customers who have not paid their order in full. |
(S.ORDERS.SHIP_STATE='KY' OR S.CUSTOMERS.STATE='KY') | A row can match either condition to be retrieved by the query. In this example, returns all orders that were ordered by customers in Kentucky or shipped to Kentucky |
(S.ORDERES.INVOICE_DATE IS NULL XOR S.ORDERS.PAID_IN_FULL = 'Y') | The query retrieves the row if exactly one condition is true. In this example, returns customers who have shipped orders, paid in full, and customers who have unshipped orders, still unpaid. |