Title: Joining columns
Last modified: April 4, 2022

---

# Joining columns

 *  [remykonings28](https://wordpress.org/support/users/remykonings28/)
 * (@remykonings28)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/joining-columns/)
 * Hey Peter.
 * Is there a way to join certain columns so it feels like the names (picture) are
   joined together instead of separate?
 * picture [https://ibb.co/19nPGQ6](https://ibb.co/19nPGQ6)
 * Dankjewel.

Viewing 1 replies (of 1 total)

 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/joining-columns/#post-15521325)
 * 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/](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

Viewing 1 replies (of 1 total)

The topic ‘Joining columns’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

## Tags

 * [column](https://wordpress.org/support/topic-tag/column/)
 * [join](https://wordpress.org/support/topic-tag/join/)

 * 1 reply
 * 3 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [4 years, 1 month ago](https://wordpress.org/support/topic/joining-columns/#post-15521325)
 * Status: not resolved