2 Replies Latest reply: Oct 12, 2012 4:02 PM by steve peroni RSS

    Which type of join ?

    steve peroni

      Dear all,

      I've two tables like these:

       

      Table1

      OrderID     Customer

      1               A

      2               B

      3               C

      4               D

       

       

      Table2

      OrderID     OrderDetail     Product

      1               1                    zz    

      2               1                    yy

      4               1                    xx    

       

       

      I need to extract only the ORDERID without any entry into Table2. In this case the OrderID 3

       

      How can I solve it ?

      Help please

       

      Thanks in advance