title: MySQL Select ALL from Left Join
body: <p>This query does not work. I want all the results from a <code>LEFT JOIN</code> where something is something. This is my exact code:</p>
  
  <pre><code>SELECT * FROM `swarovski_zones` WHERE `siteid`='200'
  LEFT JOIN `trafficviews` ON `swarovski`.`id`=`trafficviews`.`adid`
  </code></pre>
  
  <p><code>swarovski_zones</code> table is <strong>siteid 200</strong></p>
  
  <p><code>trafficviews</code> table is <strong>adid 200</strong></p>
  
  <p>The 200 is the linking variable between the tables. I want everything from both tables where the ID is 200.</p>