SQL1




, ,

< > <> <>,

<> <> < >

<> <> <>.

, :

SELECT * FROM Orders WHERE (SELECT DISTINCT snum FROM Orders WHERE cnum = 2001) = snum;

ANSI- , . ANSI .