https://bugs.freedesktop.org/show_bug.cgi?id=58586
--- Comment #2 from [email protected] --- The problem is, that there isn't a primary-key for the second table of your query and you want to edit the query. If you try to open the query, Base doesn't understand the query and opens in the SQL-mode. Second problem I saw was, that the User with ID 0 appears very often in the result of the executed query. Try the following query: SELECT "UserId", "FirstName", "LastName", "Adress", "Zip", "City", "Mail", ((SELECT MAX( "Year" ) AS "LastSubscription" FROM "T_Subscription" WHERE "UserId" = "a"."UserId" GROUP BY "UserId")) AS "LastSubscription" FROM "T_User" AS "a" With this subselsct it works. If you don't use two brackets, the filter doesn't work, because it tries to solve the subselect without brackets in the WHERE-clause. This isn't a problem from the tablecontrol but a problem, that you try code, which isn't compatible with the GUI. A query, which doesn't work correct in the query-editor, couldn't work correct in the tablecontrol of a form. -- 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
