Hi,

How do I accomplish the following SQL statement in LLBLGen Pro using Self Servicing?

SELECT * FROM Document WHERE Revision = (SELECT MAX(d.Revision) FROM Document d WHERE d.Id = Id)

Thanx,

Walter

You can implement this either by using a FieldCompareExpressionPredicate, to compare the Revision field with a ScalaryQueryExpression.

Also you may use a FieldCompareSetPredicate to implement an IN clause.

SELECT * FROM Document
WHERE Revision IN (SELECT MAX(d.Revision) FROM Document d WHERE d.Id = Id)

Thanks for your reply but can you please provide me an example? I've tried to use a ScalarExpression and a FieldCompareExpressionPredicate as you've suggested, but i can't get it to work.

An example: http://llblgen.com/TinyForum/Messages.aspx?ThreadID=12265 Let us know if you need further help.