JOIN | WordPress.org

[ad_1]

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

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer