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

       

      tmp:

      Left Join (Loss)

      Load

       

       

      acct_nbr as distinctAcct,

      [Type] as LoanTy

      Resident Loans;