Post reply

t-sql for same fields from 2 tables

  • July 21, 2008 at 2:26 pm

    #94315

    How can I get just 2 columns from a select statement that includes 2 tables?

    Ie.

    Table1 Table2

    FIrstName Donna FirstName John

    LastName Jones LastName Doe

    Select result should be...

    FirstName LastName

    Donna Jones

    John Doe

    Thank you!

    ¤ §unshine ¤

  • July 21, 2008 at 2:34 pm

    #846014

    Look up Union and Union All in Books Online. That should get you what you need.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • July 21, 2008 at 2:38 pm

    #846017

    Awesome! Thanks for the fast response!

    ¤ §unshine ¤

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply