The herebelow statement

Code: Select all

SELECT lieide.idcleunik distinct FROM identite, lieide where lieide.idcleunik=identite.idcleunik and (licleunik=1071 or licleunik=1072 or licleunik=1101 or licleunik=1106)

returns the following error
Switching to other view failed (Data view)

however it is seen as "correct" by the "Check query button"

Without the "distinct" clause, it runs.

DISTINCT is not recognized by Kexi indeed, would be good to file a wish: https://community.kde.org/Kexi/File_a_bug_or_wish