SQL Server Performance

find discrepancy between two tables

Discussion in 'General Developer Questions' started by SQL DBA, May 15, 2008.

  1. SQL DBA New Member

    Hi Experts,
    I have to find the discrepancy between two tables
    I have Table 1 with columns
    OrderID
    Date
    Quantity
    Symbol
    Table 2 with columns
    OrderID
    Date
    Quantity
    Symbol
    I want a script to find out a list of OrderIDs present in table1 but not in table 2 and a list of OrderIDs present in table2 but not in table 1.

    Could any one help me in writing this query
    thanks in advance
  2. satya Moderator

    Is this a classroom exercise?

Share This Page