Home Forums SQL Server 2005 SQL Server 2005 General Discussion Combining two query result sets. RE: Combining two query result sets.

  • May 14, 2013 at 7:13 am

    #1614975

    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):

    http://www.sqlservercentral.com/articles/T-SQL/61539/

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]