title: Left join with most recent records before a certain date
body: <p>I want to select currently active record based on a date. What I need to do is to create a view so a 'select everything' subquery is not going to work.</p>
  
  <p>but right now I can only select one column because it says</p>
  
  <blockquote>
    <p>Operand should contain 1 column(s)</p>
  </blockquote>
  
  <p>I could duplicate the select for all the fields I want to get but its going to be performance extensive, plus I have a lot of columns on the history table.</p>
  
  <p>For this simple example (link below), lets say that I need to get the phone number as well.. any idea how I should go about doing it? Thanks.</p>
  
  <p>SQL Fiddler:
  <a href="http://www.sqlfiddle.com/#!2/1ff7e/1" rel="nofollow">http://www.sqlfiddle.com/#!2/1ff7e/1</a></p>
  
  <p>I think I got it! Seems to work but need more records to try.</p>
  
  <p>SQL Fiddler:
  <a href="http://www.sqlfiddle.com/#!2/1ff7e/3" rel="nofollow">http://www.sqlfiddle.com/#!2/1ff7e/3</a></p>
  
  <p>Still not working... zzz...I added a few more test data turned out it didn't work!</p>
  
  <p>SQL Fiddler:
  <a href="http://www.sqlfiddle.com/#!2/360c1/1" rel="nofollow">http://www.sqlfiddle.com/#!2/360c1/1</a></p>
  
  <p>My bad. <strong>IT IS WORKING!</strong> I inserted two duplicate primary keys for the history. Thanks all!!!!</p>
  
  <p>SQL Fiddler:
  <a href="http://www.sqlfiddle.com/#!2/274c5/1" rel="nofollow">http://www.sqlfiddle.com/#!2/274c5/1</a></p>