Thank you. The above 2 suggestions were helpful.
2 2019-01-31 16:18:29
Topic: limitation with SQL JOINS in MVD? (3 replies, posted in SQL queries)
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?