Archives of the TeradataForum

Message Posted: Tue, 21 Apr 2009 @ 09:28:31 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Shaun

You can do what you want by using a subquery:

Try something like this. I left the loan table out but it can easily be joined back in

     Select Loan_Id,Amount

     FROM
     Tran t1,Loan l
     WHERE
     PostDate IN (SELECT MAX(Post_Date) FROM Tran t2 WHERE t1.LoanID=t2.LoanID and
     Tran_Type='D');

-Fred

	<Prev	Next>		<<First	<Prev	Next>	Last>>