奇怪的 in 子查询 问题 :

[安优小青和他的程序生活]

select goodsno from md_userinfo where username='test'
返回结果集:
'Z0076','Z0323-1','P0217-3'

而
select vt_clientNo,vt_clientname,vt_goodsNo,vt_goodsname,
vt_iostyle, vt_buyquantity,vt_salequantity from w_salebuy where vt_goodsNo in (select goodsno from md_userinfo where username='test')

和

select vt_clientNo,vt_clientname,vt_goodsNo,vt_goodsname,
vt_iostyle, vt_buyquantity,vt_salequantity from w_salebuy where vt_goodsNo in ('Z0076','Z0323-1','P0217-3')
的结果却不一样!!
前者返回的记录中没有符合'P0217-3' 的记录,不知为何??

[lsxaa]

有空值 吧

[Softlee81307]

select vt_clientNo,vt_clientname,vt_goodsNo,vt_goodsname,
vt_iostyle, vt_buyquantity,vt_salequantity from w_salebuy where vt_goodsNo in (select rtrim(goodsno) from md_userinfo where username='test')

[wyb0026]

w_salebuy 表中没有 合'P0217-3' 的纪录吧

[xluzhong]

select vt_clientNo,vt_clientname,vt_goodsNo,vt_goodsname,
vt_iostyle, vt_buyquantity,vt_salequantity from w_salebuy where vt_goodsNo in (select ltrim(goodsno) from md_userinfo where username='test')

[安优小青和他的程序生活]

to Softlee81307(孔腎) (

加上rtrim(goodsno)也不行.

to wyb0026(小小)
w_salebuy是视图,但我已经说了:select vt_clientNo,vt_clientname,vt_goodsNo,vt_goodsname,
vt_iostyle, vt_buyquantity,vt_salequantity from w_salebuy where vt_goodsNo in ('Z0076','Z0323-1','P0217-3')
是有'P0217-3'的记录的.

[安优小青和他的程序生活]

我用sqlserver 7.0 标准版,

这是协力商霸库导出后新建的几个表和视图.

真邪门!

[安优小青和他的程序生活]

靠,,我知道了,谢谢各位帮忙..

原因是:
'P0217-3' 这个字段是我手工输入的时候从sql query anlyer的结果中粘贴过来的,不知包含了什么字符适得其反,我重新输入了一下就好了,赫赫....

[Frewin]

select vt_clientNo,vt_clientname,vt_goodsNo,vt_goodsname,
vt_iostyle, vt_buyquantity,vt_salequantity from w_salebuy where vt_goodsNo in (select Isnull(goodsno,'') from md_userinfo where username='test')

[Frewin]

Isnull(goodsno,'') 取消null值

[Fibona]

肯定有空值的原因了。