Can someone help with this SQL join statement

juanc · #1 (**permalink**) 10-23-10, 08:30

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

it-iss.com · #2 (**permalink**) 10-23-10, 09:09

Hi,

try the following:

Code:

SELECT ID, post_title, post_excerpt, post_content, meta_value
FROM  wp_posts, wp_postmeta
WHERE wp_posts.post_id = wp_postmeta.post_id
AND meta_key = 'large_download_button'

juanc · #3 (**permalink**) 10-23-10, 14:08

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

Internet Services

Web Development

Digital Marketing

Consumer Tech