AND/OR/NOT queries

Applications such as Microsoft Access use query language to narrow down search results. A query can look at more than one field.

Reg. numberMakeModelDate registeredPriceTaxed
R623 PHMFordFiesta0101986800Y
P887 LHWRover2000103977500Y
X842 PLDFordMondeo0101968100N
P812 WHJPeugeot4060109967000N
T419 PCPCitroenC40109996000Y

This is a list of common terms used in query language with example usage based on the table:

  1. AND - use to find all records where the make is a Ford AND the price is less than 8000. This would return the Fiesta but not the Mondeo.
  2. OR - use to find all records where the make is a Ford OR Rover. This would only return the Ford Fiesta, the Ford Mondeo and the Rover 200.
  3. NOT - use to find all records where the make is NOT Citroen. This would return all records except the Citroen C4.

In query language, these examples would look similar to this:

  1. [Make] = "Ford" AND [Price] < 8000
  2. [Make] = "Ford" OR [Make] = "Rover"
  3. [Make] = NOT "Citroen"
Demonstration of and or not query process using sieves to filter car results
Move on to Test
next