8 Replies Latest reply: Jun 2, 2014 12:45 PM by Jason Michaelides RSS

    Taking one response from a field

    Ashley Navin

      So I'm using this table to get the type of acct each account is, but some of them are listed as two different types because they changed at some point. How do I narrow this down so that I can just get the most recent type instead of both



      Left Join (Loss)




      acct_nbr as distinctAcct,

      [Type] as LoanTy

      Resident Loans;