Hi there,
I try to build a custom query using an INNER JOIN. Unfortunately, the custom query builder doesn’t seem to recognize this command, unless I switch to “MySQL” but as soon as I save it, and open it again, it is back to SQL and doesn’t recognize the INNER JOIN - but only JOIN.
Problem is: I need to JOIN 3 tables, which works flawlessly in a “standard” wappler query (see picture) but I need it in the custom query.
Why? Because I got randomization with a custom query solved without the other solutions posted here, directly as database function.
It works when I use just one single JOIN, but I cannot use any combination of INNER JOIN, LEFT JOIN, RIGHT JOIN etc.
Thanks for your help
Community Page
Last updated:
Last updated: