Re: Newbie Query Question

From: Kingsley Sawyers <no_at_way.im.telling>
Date: Fri, 23 Jul 1999 15:47:04 +0100
Message-ID: <7n9v73$gcn$1@lure.pipex.net>

The 'where' in line 4 should be a 'select'...

This query shows all the order lines in table ITEM which have the same product & quantity as any line in order no. 605. The <>605 just means that it won't show order 605 details too.

HTH Kingsley

geraldine grubb wrote in message <37987DB2.81CF396A_at_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:47:04 CDT