Post reply

To write a query

  • June 13, 2009 at 1:24 am

    #135001

    Hi,

    I have two table as below....

    Table A

    Id Name

    1 Sunil

    2 Anil

    3 Amit

    4 RAj

    Table B

    Id Add

    1 Mumbai

    2 Pune

    I want the result from these two tables as below:

    Id Name

    3 Amit

    4 Raj

    Please help me to get the result.

    Thanks,

    Sunil

  • June 13, 2009 at 1:51 am

    #1009027

    Please don't cross post.

    Discussion already started at thread http://www.sqlservercentral.com/Forums/FindPost734274.aspx


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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