December 2, 2009 Leave a comment
Recently I came to know that we can make some complex queries in the AOT as well by adding the ranges.
SELECT * FROM EmployeePosition
JOIN * FROM PositionDetailTable
WHERE EmployeePosition.ValidFrom <= PositionDetailTable.ValidFrom
&& EmployeePosition.ValidTo <= PositionDetailTable.ValidTo
Attached is the sample AOT query that will produce the same result. you need to download and remove the .doc extension from the file.