SELECT null???
SELECT null FROM SD_SALELOG SD WHERE SD.SALELOG_NO=#M_SALELOG_NO#
SELECT null是什么意思啊?没有列?
------解决方案--------------------一般用在EXISTS子句里面
SQL> select * from test;
ID NAME
---------- --------------------
2 LOVE2008rr
4 lei
1 WZKHELLO WORLD
3 WZKHELLO WORLD
5 HELLO
6 HEIHEI
已选择6行。
SQL> select * from t;
ID NAME
---------- ------------------------------
1 WZK
1 ZX
SQL> select * from test where exists(select null from t where t.id=test.id);
ID NAME
---------- --------------------
1 WZKHELLO WORLD
SQL>