This project has moved. For the latest updates, please go here.

CabCount = 0 search does not work.


The SQL for the CAB rollup code should account for the fact that the field may be NULL. A NULL should be replaced with a 0 before the comparison (or a check explicitly for null).
Need to use COALESCE(Count(*), 0) on the CR1, CR2 lines to get the CabCount as non null.
Then need to select from that table according to the CabCount criteria somehow.
Not a huge issue as most people will be searching for cabcount > n