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!
Solved! Go to Solution.
Hello @Milliman ,
You can replicate it by using a join, union and filter tool.
If you need anything else let me know 🙂
Regards
This approach works for a SQL Where clause and not as a left join.