Title: Display SQL Query Results?
Last modified: September 20, 2025

---

# Display SQL Query Results?

 *  Resolved [junket1234](https://wordpress.org/support/users/junket1234/)
 * (@junket1234)
 * [8 months, 3 weeks ago](https://wordpress.org/support/topic/display-sql-query-results/)
 * I’ve used the SQL Query Builder to make a sweet table of concatenated data (drawing
   on four tables), and I need to be able to make this available on the front end…
   but I see no shortcode option or any other way to do that. 
   Am I missing something
   totally obvious?

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [8 months, 2 weeks ago](https://wordpress.org/support/topic/display-sql-query-results/#post-18649903)
 * Hi [@junket1234](https://wordpress.org/support/users/junket1234/)
 * Thank you for reaching out.
 * The Query Builder does not have any shortcodes. You can make a database view 
   for your query and use your view in the App Builder. Similar to database tables,
   database views can be used with the App Builder.
 * **TIP **Be sure to enter **CREATE OR REPLACE VIEW** in the Query Builder rather
   than **CREATE VIEW**. As a result, you can save your query and run it as often
   as you like.
 * The MySQL documentation for views is available here:
   [https://dev.mysql.com/doc/refman/8.4/en/create-view.html](https://dev.mysql.com/doc/refman/8.4/en/create-view.html)
 * Hope this helps,
   Peter
 *  Thread Starter [junket1234](https://wordpress.org/support/users/junket1234/)
 * (@junket1234)
 * [8 months, 2 weeks ago](https://wordpress.org/support/topic/display-sql-query-results/#post-18649918)
 * Thanks for the reply!
   OK, interesting — I had that idea, actually, and created
   a db view with the query … but I assumed that since the App Builder wizard only
   showed “tables” as an option, my new view wasn’t there. It was.That works.
    -  This reply was modified 8 months, 2 weeks ago by [junket1234](https://wordpress.org/support/users/junket1234/).
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [8 months, 2 weeks ago](https://wordpress.org/support/topic/display-sql-query-results/#post-18649964)
 * OK, I see how such a prompt can be misleading. We’ll fix that with the next update.
 * Thank you for reporting back! 🙏

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Display SQL Query Results?’ 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/)

 * 3 replies
 * 2 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [8 months, 2 weeks ago](https://wordpress.org/support/topic/display-sql-query-results/#post-18649964)
 * Status: resolved