Eugene Elutin (5/14/2013)
Lynn Pettis (5/14/2013)
Eugene Elutin (5/14/2013)
William Gary Wright (5/14/2013)
I left the office last night being half way done writing a script to create a database with some data in it for you all to look at. I came in this morning and read the new replies to my post. I had never considered a join. All of the examples of joins I have seen there was always an = involved and I had not seen >= used in a join. This worked great and it makes sense to me.Thanks Lynn,
Bill
PS
How does this points thing work?
This article is worth to read (about hidden "RBAR" in triangular joins):
Eugene,
Yes, it is a good article on triangular joins, I just hope you don't think that the code I provided is a triangular join. It is actually a bound join with a lower an upper bound.
No, it has nothing to do with your code. Just OP has stated that he has never seen JOINs with "<=" used before. So, I thought, before OP will became to excited about it, he better to be aware of triangular join problem which may occur when "non-equal" compare is used in joins.
Okay, just wanted to be sure. Didn't want the article to scare off the OP from the code I provided.
Definitely a good thing to point out the issues that can occur with triangular joins.