How to set the expression to get correct values

[#1]

Hi,

I have to use below expression to get MAX(TransDate) in straight table

Max({<TransTypeDomain={"Receipt"},Transtype={"DD","SO"},AccountTypeID={"19865"}>}TransDate)

when ActualAccountID=AccountID

Could anyone help me how to change the above expression to get correct values. Here ActualAccountID is column in Table1 and AccountID is column in Table2.

Please help me.

Thanks.

[#2]

Thanks and when I am testing the result in SQL database it is showing correct values but when I am using in qvw it is showing incorrect values what it means  I used below in SQL

select Ref,Max(Transdate) from [DBO].[ACCOUNT]a
left join
[DBO].[TRANSACTIONS]b
on a.accountid=b.accountid
and b.ActualAccountID=a.AccountID
where TransTypeDomain='Receipt' and Transtype in ('DD','SO') and AccountTypeID=('19865')

group by ref
order by ref

[er_mohit]

Try this may be helps you

Max({<TransTypeDomain={"Receipt"},Transtype={"DD","SO"},AccountTypeID={"19865"},

ActualAccountID=P(AccountID)>}TransDate)