The C Users' Group Library 1994 August/wc-cdrom-cusersgrouplibrary-1994-08.iso/listings/v_02_01/2n01056a

Text File | 1990-11-26 | 309b | 13 lines

SELECT DISTINCT Machine#
FROM MachineParts Work1
WHERE NOT EXISTS
     (SELECT * FROM PickList
      WHERE NOT EXISTS
           (SELECT * FROM MachineParts Work2
             WHERE ((Work1.Machine# = Work2.Machine#)
               AND (Work2.Part# = PickList.Part#))
            )
      );