Joining columns

Hi Remy,

You can create a view and use your view in publications and projects. In projects views are not updatable! Since you are a premium user as well, you can also write custom queries directly in the Data Publisher. This is documented here:
https://wpdataaccess.com/docs/documentation/data-publisher/custom-queries/

Concat allows you to concatenate strings. Your query could look like:
select datum, thema, concat(aanhef, ' ', voorgvoegsel, ' ', naam) as naam from table

Does this help?
Peter