inner join with multiple tables is not working
Adriano,
Please explain what is not working exactly.
I understand nothing from your screenshots. Please provide a little more detailed information about this.
Please check the error message returned by the server action in your browser console.
Ok, thanks. We are going to check this.
Did you try without using aliases? As far as I know there are still bugs relating to aliases. I sent Teodor a video showing this a little while ago. I’ve been using inner joins without aliases and they work fine.
Before using the query with bindings etc. on the final page, I usually test the query is working, using the ‘Open in Browser’ button while creating the action file. It’s very useful for debugging and making sure the output is what you want. Only once I know the action file is working do I start on the actual page.
thanks Tom for comment