title: sql query that not show all records
body: <p>i have a problem with a query, for example with this one i can retrieve the records:</p>
  
  <pre><code>SELECT 
  l.*, 
  ll.f_cocacola as cocacola, 
   le.name AS deposit, 
   lp.price
  FROM 
   KPC AS l, 
   KPC_cocacola AS ll, 
   KPC_deposit AS le, 
   KPC_price AS lp 
  WHERE 
  l.cod_deposit = le.id_deposit 
  AND l.code = ll.code
  AND lp.code = l.code
  AND l.code_deposit = '002365' 
  </code></pre>
  
  <p>but now i need to include another date from another table -intranet- that has the fields <em>code</em> and <em>url</em> then need to show from this table the <em>url</em> field .. keep in mind that the relationship is on the <em>code</em> field.</p>
  
  <p>so i change the query in this way:</p>
  
  <pre><code>SELECT l.*,ll.f_cocacola as cocacola, le.name AS deposit, 
  lp.price, lintranet.url 
  FROM tableX AS l, intranet_cocacola AS ll, tableX_deposit AS le, 
  tableX_price AS lp, 
  tableX_intranet as lintranet 
  WHERE l.code_deposit = le.id_deposit
  AND l.code = ll.code
  AND lp.code = l.code 
  AND l.code = lintranet.code
  AND l.code_deposit = '456852147'
  </code></pre>
  
  <p>but the issue is that some records don't have a <em>url</em> and if is not exist a <em>url</em> then this query don't show me the record .. well what i need that even if there is not a <em>url</em> associated to a record i want to see that recorda, thanks</p>