I can't help, Bernie...

In all queries, AFAIR, I always use only CHECK (or some/all fields), or 
only CHECKPLUS (on some/all) - I think I've never mixed them.

   - Mike


On 06/04/2018 08:27, Bernie van't Hof wrote:
> 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.
> 
> Anyone help?
> 
> - Bernie