title: For each Stock Bid select the related Bidder's Most Recent SignIn
body: <p>I know similar has been asked and answered previously but despite hours on it I still can't figure out how to</p>
  
  <pre><code>Select StockBids.*  along with the 
  MOST RECENT MemberSignIns.Lat/Long 
  from the following two tables
   wWhere StockBids.MemberID = 'MSFT' 
  </code></pre>
  
  <p>see <a href="http://sqlfiddle.com/#!6/7b9c7/2" rel="nofollow noreferrer">http://sqlfiddle.com/#!6/7b9c7/2</a>  for test data</p>
  
  <p>As full explanation returned should be rows for <code>StockBids.ID = 24, 26 28</code> AND because MemberID 4 submitted both <code>StockBid.ID = 24 and  28</code> these two rows should have Lat/Long values of <code>40.692259/-73.766641</code> as derives from his latest <code>MemberSignin.ID = 16</code>.   </p>
  
  <pre><code>StockBids
  ID  MemberID    EntityAbbrev    BidPrice    BidShares
  24    4         MSFT          7.43        10
  25    4         AAPL          7.43        10
  26    5         MSFT          7.36        20
  27    6         AAPL          7.29        30
  28    4         MSFT          7.22        40
  </code></pre>
  
  <p>JOINED ON StockBids.MemberID = MemberSignIns.MemberID</p>
  
  <pre><code>MemberSignIns
  ID  MemberID    UTC             Lat       Long
  11    4      6/23/17 16:23     40.736999    -73.875247
  12    4      6/23/17 16:32     40.782117    -73.980739
  13    5      6/23/17 16:40     40.643339    -73.977714
  14    6      6/23/17 16:48     40.760262    -73.993287
  15    7      6/23/17 16:56     40.722414    -73.992452
  16    4      6/23/17 17:04     40.692259    -73.766641
  </code></pre>