I have a cascading dropdown where the data list if an INNER JOIN table, I want to CONCAT two of the fields from the joined table. What is the syntax, the help popup talks about {thistable_N} for joined tables but I haven't been able to work out the correct syntax. I am getting MySQL errors for column not found.
The LIST which is being used is an INNER JOIN of existing tables on the site database
The LIST which is being used is an INNER JOIN of existing tables on the site database