https://bugs.documentfoundation.org/show_bug.cgi?id=168149
--- Comment #6 from Eyal Rozenberg <eyalr...@gmx.com> --- (In reply to Regina Henschel from comment #5) > (In reply to Eyal Rozenberg from comment #2) > > > SELECT t1.name, t2.name > > FROM selection_ AS t1, selection_ AS t2 > > WHERE t1.'favourite color' = t2.'favourite color' AND t1.name < t2.name; > > Why a complex SELECT statement where a simple filter (function or database > range feature) is sufficient? A simple filter is not sufficient, since I'm producing _pairs_ of records/rows: All pairs of people who like the same color. -- You are receiving this mail because: You are on the CC list for the bug.