June 25 | Create queries that compare two fields of the same data type (date, integer, etc.).
For example, you may want to compare the date of a pipe clean task to the date of a CCTV inspection, to ensure a pipe was inspected after cleaning. Or you could compare the length of a CCTV inspection to the length the pipe to identify partial inspections.
See more in: Create Queries to Compare Two Fields