title: Virtuemart joomla
body: <p>Does anyone know how to link a product with its picture in VirtueMart in Joomla?</p>
  
  <p>I've tried :</p>
  
  <blockquote>
    <p>$query = "SELECT  a.<em>, c.</em>".
                  " FROM #__virtuemart_products_pl_pl as a".
                      " LEFT JOIN #__virtuemart_medias as c ON c.virtuemart_media_id = a.virtuemart_product_id" ;</p>
  </blockquote>
  
  <p>But its not good, pictures and products don't match.</p>
  
  <p>I don't see any connection between them.</p>