Can someone help with a join SQL statement

[juanc]

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

[r937]

... 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

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

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

[juanc]

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