Post reply

How to find the Difference in Records between two tables with the same Structure

  • February 13, 2008 at 4:19 am

    #69567

    Hi,

    I need to find the difference of records between two tables TABLE_A and TABLE_B which have same structure.

    There are 200 records more in TABLE_B when compared to TABLE_A.

    How can I fetch those 200 records.

    Regards,

    Ezhilan

  • February 13, 2008 at 5:06 am

    #777753

    You can use SQL Data Compare from Redgate. As you can download trail version from the site for 14 days it will suite for you




    My Blog: http://dineshasanka.spaces.live.com/

  • February 13, 2008 at 6:27 am

    #777784

    SELECT

    b.*

    FROM table_b b LEFT OUTER JOIN

    table_a a

    ON b.key_col = a.key_col

    WHERE a.key_col IS NULL

    Greg

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.

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

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