SQLite database.
I have two tables. Their Link has been pre-established: one to many.
I add the "one" table in the Query Editor.
I select some fields from the "one" table.
I add the "many" table to the right of the "one" table in the Query Editor.
The pre-established link automatically appears. It appears as an INNER JOIN.
I change the join to LEFT OUTER JOIN.
The join icon correctly displays as a LEFT OUTER JOIN as shown here:
roducts:vstudio:help:query_editor" target="_blank" rel="nofollow">https://valentina-db.com/docs/dokuwiki/v10/doku.php?id=valentinaroducts:vstudio:help:query_editor
I select some fields from the "many" table.
The query does not produce the result I was expecting: I know some of the "one" table entries do not have entries in the "many" table, however they do not appear in the result.
The Query tab: the "many" table is the FROM table.
The Query tab: the FROM table change (from the "one" table to the "many" table) occurs immediately after I add the "many" table.
If I remove the link, add the link, change the join to LEFT OUTER JOIN, the query produces the result I was expecting. However, the join icon displays a RIGHT OUTER JOIN.
(Per my notes, I have experienced this in the past.)
Windows 10 2004 64-bit
Valentina Studio Pro 10.5.6 (64-bit)