Can someone help with a join SQL statement

Databases
1

Hi

I’ve got a Wordpress powered site but I’ve also got a few php pages outside of my WP installation which I need to query the database that powers my WP site. Everything is fine apart from the fact that I don’t really know how to write a particular SQL statement which involves a join. I was wondering if someone could help me.

Basically what I want is to be able to get the ID, post_title, post_excerpt, post_content from the wp_posts table and then the meta_value from the table wp_postmeta table but where the meta_key = “large_download_button” and the ID from wp_posts matches the post_id on wp_postmeta

Of course wp_posts.ID and wp_postmeta.post_id are the common fields between the two tables.

These are the two tables wp_posts and wp_postmeta

wp_posts
ID
post_author
post_date
post_date_gmt
post_content
post_title
post_excerpt
post_status
comment_status
pint_status
post_password
post_name
to_ping
pinged
post_modified
post_modified_gmt
post_content_filtered
post_parent
guid
menu_order
post_type
post_mine_type
comment_count

wp_postmeta
meta_id
post_id
meta_key
meta_value

many thanks for your help

2

Hello thank you very much that worked! I really appreciate your help.

3

let’s see how closely the SQL solution matches this requirement statement


[COLOR="DeepSkyBlue"]-- ID, post_title, post_excerpt, post_content from wp_posts [/COLOR]
SELECT post.ID
     , post.post_title
     , post.post_excerpt
     , post.post_content 
[COLOR="deepskyblue"]-- meta_value from wp_postmeta[/COLOR]
     , meta.meta_value
  FROM wp_posts AS post
INNER
  JOIN wp_postmeta AS meta
[COLOR="deepskyblue"]-- the ID from wp_posts matches the post_id on wp_postmeta[/COLOR]
    ON meta.post_id = post.id
[COLOR="deepskyblue"]-- where the meta_key = "large_download_button"[/COLOR] 
   AND meta.meta_key = 'large_download_button'