https://bugs.freedesktop.org/show_bug.cgi?id=42165
--- Comment #6 from [email protected] --- Created attachment 68956 --> https://bugs.freedesktop.org/attachment.cgi?id=68956&action=edit Two queries with two joins - query of GUI didn't work. @comment 5: The problem appears, when you create a query with two joins, not only one. The GUI creates every time the procedure: first the tables, then the definition of the relations. This works for a normal "join" like FROM table1, table2, table3 WHERE table1.nameID = table2.ID ... This doesn't work for right or left joins. There it must look like FROM table1 LEFT JOIN table2 ON table1.nameID = table2.ID LEFT JOIN table3 ON ... When a query is created with "JOIN" there must be a definition of the relation directly after the definition of a join. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
