https://bugs.documentfoundation.org/show_bug.cgi?id=157916
--- Comment #3 from Robert Großkopf <[email protected]> --- (In reply to Alex Thurgood from comment #1) > > SELECT * from ipgalore as t1 LEFT OUTER JOIN (priority as t2,owner_list as > t3,inventor_list as t4) ON (t2.fmpro_id = t1.fmpro_id AND t3.fmpro_id = > t1.fmpro_id AND t4.fmpro_id = t1.fmpro_id) > > If this is the kind of query you are talking about, then I can confirm the > bug report. This query won't be editable in any database connected to Base. It is missing the primary key of second table. Should be something like SELECT `table1`.*, `table2`.* FROM `database`.`table1` `table1`, `database`.`table2` `table2` WHERE `table1`.`ID` = `table2`.`ForeignkeyID` Such a query will be created for 2 tables where second table has a foreignkey for the first table. All fields of both tables will be shown. If you change the query to SELECT `table1`.*, `table2`.* FROM `table1`, `table2` WHERE `table1`.`ID` = `table2`.`ForeignkeyID` you could input data into this query. -- You are receiving this mail because: You are the assignee for the bug.
