JOIN

  • Resolved quarlton

    (@quarlton)


    2 years, 3 months ago

    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

    (@kimmyx)

    Hi @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

    (@quarlton)

    Hi @kimmyx

    That worked!
    Many thanks,

    Dave

    Plugin Contributor Kim L

    (@kimmyx)

    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.

Tags