Results 1 to 2 of 2

Thread: Newbie Question

  1. #1
    Join Date
    Oct 2005
    Posts
    1

    Red face Unanswered: Newbie Question

    Table 1

    Order Number
    1234
    4321
    5601

    Table 2

    Order Number
    1234
    4321

    How do I Get SQL to Return that the Order number 5601 does not match any Order number in Table 2:

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Try:

    SELECT Table1.OrderNumber
    FROM Table1 LEFT JOIN Table2 ON Table1.OrderNumber = Table2.OrderNumber
    WHERE Table2.OrderNumber Is Null
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •