title: What should be PHP/MySQL query for the following requirement?
body: <p>It is a shopping cart, where user can add product to watchlist. Have a seprate page of User's watchlist where all product apepears that has been added to watchlist by that particular user. <code>product_images</code> table is separated from product table since 1 image can have multiple images.</p>
  
  <p><strong>MySQL Tables</strong></p>
  
  <pre><code>Table "product" :
      pid(pk),name,price, etc...
  
  Table "watchlist" :
      wid(pk),pid(fk),userid(fk)
  
  Table "p_images" :
      image_id(pk),pid(fk),image_name
  </code></pre>
  
  <p>I want to fetch all information from <code>product</code> table and only 1st image of that particular product from <code>p_images</code> table.
  product should be fetch by pid in <code>watchlist</code> table.</p>