My Visual Database — limitation with SQL JOINS in MVD?

Re: limitation with SQL JOINS in MVD?

null@example.com (Paul) — Tue, 05 Feb 2019 17:06:22 +0000

Thank you. The above 2 suggestions were helpful.

Re: limitation with SQL JOINS in MVD?

null@example.com (sibprogsistem) — Thu, 31 Jan 2019 17:59:35 +0000

http://myvisualdatabase.com/forum/viewtopic.php?id=4727

Re: limitation with SQL JOINS in MVD?

null@example.com (tcoton) — Thu, 31 Jan 2019 16:49:11 +0000

Sqlite does not support Right and Full outer joins, you have to use workarounds see: https://www.sqlitetutorial.net/sqlite-full-outer-join/, using a MySQL database connection might support Right and Full outer joins.

limitation with SQL JOINS in MVD?

null@example.com (Paul) — Thu, 31 Jan 2019 16:18:29 +0000

Hello Dmitriy,
I am pretty new to all this, so please excuse me if this is a "non-issue question".

I was trying to tie a push button action to a SQL search. In the process,
while trying to join 2 tables in a search, I got this error message from MVD:
"ERROR: RIGHT and FULL OUTER JOINs are not currently supported ".
(the SQL statement was actually calling for a LEFT OUTER JOIN).
Is that a limitation in the program, and if so, do you have any plans to add that functionality in an upgrade?
If it is a current limitation, is there a way around it?