Re: Q: sql query where criteria is not all contained in each row

>SELECT * FROM invoice_detail WHERE product_id in (002,005);

Ehhh, no! This only checks if product_id of a certain row is either '002' or '005'. This is not what John needs. In his case, one row could have product_id '002', another '005'.

Arjan. Received on Mon Aug 03 1998 - 00:02:34 CDT