Help with SQL query

Hi Team,

I’m looking to pull some data with SQL, but I believe I need to create a sub query in order to achieve what I’m looking for.

I’m using the tables wp_postmeta and wp_posts. In postmeta I have SKUs listed in for each of my products, and I’m looking to create a spreadsheet in my site that has the ‘add to cart’ button for each product.

In order to to that I will need to align the SKUs with their respective IDs which is found in the table wp_posts.

So I’ve been trying to nest queries to pull the ID column from wp_posts and the SKU column(or rather the meta_value column) then that way I can line them up and then use excel to create a CSV and import.

Can someone please help me on how to design this query. I only know SQL well enough to get a few things done, but this nested stuff is a whole new level.

Thanks!!