9 Replies Latest reply: Sep 16, 2013 10:48 AM by Gysbert Wassenaar RSS

    How can you view rows that are in one table and not another?

    Afraz Jaffri

      I have loaded 2 tables with exactly the same columns: TABLE_A and TABLE_B.

       

      I want to be able to view the rows that are in TABLE_B but not in TABLE_A. The 2 tables are very large (around 160 million rows) and there are around 5 million extra rows in TABLE_B so the most efficient way of doing this would be very helpful. Just being able to see some of the rows that are different would still be helpful.

       

      Many thanks!