Newbie Query Question

From: geraldine grubb <ggrubb_at_indiana.edu>
Date: Fri, 23 Jul 1999 09:35:30 -0500
Message-ID: <37987DB2.81CF396A@indiana.edu>

Hi,

Can someone explain the need for <>605 in the following query:

   select ordid, prodid, qty

        from item
       where (prodid, qty)  IN
                                (where prodid, qty
                                 from item
                                where ordid = 605)

    and ordid <> 605;

Please reply to ggrubb_at_indiana.edu.

Thanks
gg Received on Fri Jul 23 1999 - 09:35:30 CDT