Title: JOIN
Last modified: November 29, 2022

---

# JOIN

 *  Resolved [quarlton](https://wordpress.org/support/users/quarlton/)
 * (@quarlton)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/join/)
 * I’m having a problem creating a query using an INNER JOIN.
 * Accessing the WP database using MyPHP I can run the followig query:
 *     ```
       SELECT wp_terms.term_id,
       	   wp_terms.slug	   
       FROM wp_terms
       INNER JOIN wp_term_taxonomy USING (term_id)
       where wp_term_taxonomy.taxonomy='nav_menu';
       ```
   
 * And it runs successfully and returns a list of Menus
    Unfortunately when I try
   and run it in Query Builder it just gives me a blank screen with the date and
   time.
 * Any help would be much appreciated.
 * I am using the free version of WP Data Access

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

 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/join/#post-16245219)
 * Hi [@quarlton](https://wordpress.org/support/users/quarlton/),
 * Can you try removing the `;` from the last line?
 * So your query should now look like this:
 *     ```
       SELECT wp_terms.term_id,
       	   wp_terms.slug	   
       FROM wp_terms
       INNER JOIN wp_term_taxonomy USING (term_id)
       where wp_term_taxonomy.taxonomy='nav_menu'
       ```
   
 * Let us know if this helps!
 *  Thread Starter [quarlton](https://wordpress.org/support/users/quarlton/)
 * (@quarlton)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/join/#post-16245229)
 * Hi [@kimmyx](https://wordpress.org/support/users/kimmyx/)
 * That worked!
    Many thanks,
 * Dave
 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/join/#post-16245233)
 * Hi Dave,
 * Great!
 * I’ll mark this thread as resolved now.
 * Feel free to open a new one if you have new questions. 🙂

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

The topic ‘JOIN’ 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

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

 * 3 replies
 * 2 participants
 * Last reply from: [Kim L](https://wordpress.org/support/users/kimmyx/)
 * Last activity: [3 years, 5 months ago](https://wordpress.org/support/topic/join/#post-16245233)
 * Status: resolved