Home Forums SQL Server 2008 T-SQL (SS2K8) Sql Query RE: Sql Query

  • March 18, 2013 at 7:40 pm

    #1598251

    Jeff Moden (3/18/2013)

    SqlServerLover (3/18/2013)

    Thanks SSCrazy. Union all does not work in my case as i do not want two rows .........

    but left join worked.. thanks.

    Since you said there was no fixed key to join the 2 two results, how'd you manage to pull off a Left Join?

    May be he has some "flexible" or "broken" key?

    :hehe:

    _____________________________________________
    "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]