Table1 Table2 Eid Packet Eid Packet 108020002000012013 108020002000012013 108020002000022013 108020002000022013 108020002000032013 108020002000052013 108020002000042013 108020002000062013 108020002000052013 108020002000072013 108020002000062013 108020002000102013 108020002000072013 108020002000112013 108020002000082013 108020002000092013
two tables 1st table un matched records Matched records 2nd table un Matched 108020002000012013 108020002000032013 108020002000102013 108020002000022013 108020002000042013 108020002000112013 108020002000052013 108020002000082013 108020002000062013 108020002000072013
SELECT t1.EidPocket FROM table1 AS t1 INNER JOIN table2 AS t2 ON t1.EidPacket = t2.EidPocket
SELECT EidPocket FROM table1 AS t1 WHERE EidPocket NOT IN (SELECT t2.EidPocket FROM table1 AS t1 INNER JOIN table2 AS t2 ON t1.EidPacket = t2.EidPocket)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)