What is the syntax for CONCAT label for data in cascading dropdown?

[hdouglas]

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

 

[startpoint]

{thistable}.column_name1,'-',{thistable}.column_name2

 

[hdouglas]

Hi, thanks for the quick response, however that just gives me a 1054 - unknown column name error.
If I take fields which are in the main table of the list, ie not joined, then it works. The problem here is I need a couple of fields from the INNER JOIN

 

[troester]

You must do the joins yourself in the concat, for examples see http://fabrikar.com/forums/index.php?wiki/database-join-element/#or-concat-label-examples