信管网cnitpm606012210***： [回复]
解析: ｓｅｌｅｃｔ sno from sp where sno in （ｓｅｌｅｃｔ sno from sp where pno in（ｓｅｌｅｃｔ pno from sp where sno=“168“））；
或者: ｓｅｌｅｃｔ sno from sp spx where exists （ｓｅｌｅｃｔ ＊ from sp spy where spy.sno=1168“ ａｎｄ exists （ｓｅｌｅｃｔfrom sp spz where spz.sno=spx.sno ａｎｄ spz.pno=spy.pno））；
信管网cnitpm606012210***： [回复]
解析: ｓｅｌｅｃｔ ＊from sp where sno in （ｓｅｌｅｃｔ sno from sp where pno in（ｓｅｌｅｃｔ pno from sp fromsp where sno=“168“））；
或者: ｓｅｌｅｃｔ ＊from sp spx where exists （ｓｅｌｅｃｔ ＊ from sp spy where spy.sno=1168“ ａｎｄ exists （ｓｅｌｅｃｔfrom sp spz where spz.sno=spx.sno ａｎｄ spz.pno=spy.pno））；
|