|Subject:||CHECK and CHECKPLUS
|Date:||Fri, 6 Apr 2018 17:27:27 +1000
|From:||Bernie van't Hof <email@example.com>
Pdox allows a query to contain both CHECK's and CHECKPLUS's which roughly translate to SELECT
DISTINCT and SELECT in sql.
sql does not allow both in the same query due to possible uncertainties/ambiguities.
I thought I had this nailed, but on closer inspection it seems my recollection of how pdox works
in this regard is not
so clear, although I do remember sometimes struggling to get the mix right.