Home Forums Article Discussions Article Discussions by Author Discuss content posted by Douwe Miedema Show content differences between two tables/views RE: Show content differences between two tables/views

  • October 16, 2008 at 2:42 am

    #885684

    You could try,

    select *

    into D

    from A

    where not exists (select 'x' from C where C.key=A.key)

    union

    select *

    into D

    from B

    where not exists (select 'x' from C where C.key=B.key)