title: SQL help, left join with filter
body: <p>Please have a look at the SQL in the SQLFiddle link below.</p>
  
  <p><a href="http://sqlfiddle.com/#!9/22e094/4" rel="nofollow noreferrer">http://sqlfiddle.com/#!9/22e094/4</a></p>
  
  <p>My goal is to get all the records from Table1, and if SecId exists in Table2, join only if the status is 'Y'.</p>
  
  <p>Result should be that it pulls from table 1: ID 1 and 2. And for ID 1, it successfully left joins Table2 and pulls 'Y'</p>
  
  <p>As you can see in the fiddle, I tried 3 different ways but can't seem to get it. </p>
  
  <p>It's got me stumped... Help would be awesome! :)</p>