Replicating Comparison Operator used in the JOIN conditions of a SQL statement

[Milliman]

Hello,

I'm wondering how I could replicate the comparison operator used to filter dates in the JOIN ON statement below:

SELECT Key, Date FROM A

LEFT JOIN B

ON (A.Key = B.Key)

AND (A.Date > B. Date)

Thank you!

[afv2688 · Accepted solution]

Hello @Milliman ,

You can replicate it by using a join, union and filter tool.

If you need anything else let me know 🙂

Regards

[R726319]

This approach works for a SQL Where clause and not as a left join.