How to recover elements from another table in an SQL query?

Question

I took data from a table wp_posts and now I need to get data from the table wp_postmeta which coincide with the ID captured in the table wp_posts. These data are the product_img1, product_img2, product_img3 as shown in the image below:

The SQL I used to capture information from wp_posts is this:

<?php

    require("configs/conxao.php");
    $conectado = $pdo->query("SELECT * FROM wp_posts WHERE post_type = 'wpcproduct'");
    $conectado->execute();

    while($produtos = $conectado->fetch(PDO::FETCH_ASSOC)){

        echo $produtos["ID"]."<br>";                                
        echo $produtos["post_title"]."<br>";

    }

?>  

Can you help me finish this SQL?

Answer 1

You did not pass the layout of the tables, but I believe that both have a primary key, which will make the connection between both ( what we call Join ).

Your select would look something like this.

select p.*, pm.*  
from wp_posts p  
join wp_postmeta pm on p.post_id = pm.meta_id 
WHERE p.post_type = 'wpcproduct'