Swift-Kuery icon indicating copy to clipboard operation
Swift-Kuery copied to clipboard

DISTINCT doesn't seem to work with JOIN

Open fwgreen opened this issue 4 years ago • 0 comments

Both versions give duplicate results:

Select.distinct(from: tbl1).join(tbl2).on(joinColumn2 == joinColumn1).where(whereClause)

Select(from: tbl1).join(tbl2).on(joinColumn2 == joinColumn1).where(whereClause)

fwgreen avatar Sep 12 '19 00:09 fwgreen