java Hibernate条件内部联接查询
有人知道如何使用Hibernate条件编写以下sql查询吗:
select log1.Status, nm.TransactionId,* from NonMemberTransaction nm
inner join
(
SELECT status,NonMemberTransactionId
FROM MessagingLog m1
WHERE CreatedDate = (select max(CreatedDate) from MessagingLog m2 where m1.NonMemberTransactionId=m2.NonMemberTransactionId)
) log1
on nm.TransactionId=log1.NonMemberTransactionId
谢谢
共 (0) 个答案