https://bugs.documentfoundation.org/show_bug.cgi?id=126178
--- Comment #14 from Robert Großkopf <[email protected]> --- (In reply to mc from comment #13) > Created attachment 200815 [details] > ORDER BY, two tables with same fields name > > @robert > Not see difficulties. In ORDER BY need to declare the name of Table And now set code only to connect the tables: SELECT "Table1".*, "Table2".* FROM "Table1", "Table2" WHERE "Table1"."ID" = "Table2"."T1ID" (set a foreignkey to Table2 but there is no difference) Execute the query, try to order by GUI - doesn't work. Its the same reason. Will only work if I set all fields of the second table with alias. The GUI will work with internal HSQLDB with 2 tables the same as with one table and 2 fields with same name. The GUI won't work with internal Firebird with 2 tables, also not with one table and 2 fields and the same name. You could create such a query in GUI by choosing the field a second time and sort this field, because there has been a table added. -- You are receiving this mail because: You are the assignee for the bug.
