#148 View table join lines on table 2 is a "Left join" in SQL

[Anonymous]

Ticket type : Incident

Description : I am working my through the example "Assets".

The View called Assets shows 6 tables with 5 relationship lines between them.

Editing the properties of a line shows that table 1 "all properties" is selected to give a LEFT JOIN in the SQL FROM section. Selecting table 2 also results in a LEFT JOIN.

Unticking the box gives an INNER JOIN.

Should selecting the table on the right-hand-side (table 2) result in a RIGHT JOIN? If not, how do you select RIGHT JOIN?

System information : Windows 64 bits / Windows 10 Pro

[Anonymous]

I would like to add further to this as a pssible use of the 2 checkboxes:
Table 1 Table 2 - result
0 0 - Inner join
1 0 - Left join
0 1 - Right join
1 1 - Full outer join

At the moment, the two tickboxes are mutually exclusive, like a radio button... only one can be ticked at any one time.

[Neuts-jl]

This is not an incident, it is a limitation of SQLITE because it works in MySQL.The right join was not supported by SQLITE 3 NSBase respected this limitation by preventing the simultaneous checking of the 2 check boxes. The version of SQLITE 3.45.1 allows it, while waiting for the NSBase update, you can use the dll https://www.sqlite.org/2024/sqlite-dll-win-x64-3450100.zip
You download this file, you unzip it and you copy this DLL into the NSBase directory under the name sqlite-64.dll. Then in the query editor, you go to SQL mode, you uncheck "no-visual query" .
Sincerely

[Neuts-jl]

SQLITE 3.45.1 , add in NSBase >=V1.13.0