On Thu, Sep 07, 2017 at 09:51:07PM +0200, R Smith wrote:
> INTERSECT will happily match however many columns you desire (and specify),
> there is no need to match full records or single keys specifically.
But the two queries on either side of the set operator must have the
same number of columns (and in strongly-typed RDBMSes, the same types).
That's a huge constraint.
sqlite-users mailing list