I just tried it on my query and both of them appear to have returned the same results, so I suspect that you're correct about them being the same.

wbrianwhite (5/12/2009)

---

In what way was simple set logic unable to perform this operation? It looks like this could be solved with left outer joins and is null tests. ...

How could I leverage this to get, say, the "most current" version of a contract (i.e., either the contract currently in effect or the latest contract even if it was...