ども、DVです。 こんなんでいかがでしょう。 select * from customer where id in ( select id from c_order group by id having count(distinct product) = 3 ) ----------------------------------------- DV(dv @ mbd.nifty.com) 2003/12/11 11:54 -----------------------------------------