Home Forums SQL Server 2008 T-SQL (SS2K8) find record in 1 table not in another one without any primary key RE: find record in 1 table not in another one without any primary key

  • November 9, 2016 at 10:31 am

    #1911458

    J Livingston SQL (11/9/2016)

    maybe...

    SELECT *

    FROM Table_A

    EXCEPT

    SELECT *

    FROM Table_B

    Further on J L's fine answer, use CTEs if the structures/data types do not match

    😎