select * from TX where ID +ITMI not in (SELECT ID +ITmi FROM VENDOR group by ID,ITmi )~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ select * from TX where ID +not (ITMI in (SELECT ID +ITmi FROM VENDOR group by ID,ITmi )) //是这样吧...
select * from TX where not (ID +ITMI in (SELECT ID +ITmi FROM VENDOR group by ID,ITmi ))
这样试试看: select * from TX where (ID +ITMI) not in (SELECT ID +ITmi FROM VENDOR group by ID,ITmi )
我建了一个FORM1和一个FRAME2. 我在FORM1建了一个按钮来调用FRAME2怎么不行啊
不好意思我没有分了!select * from TX where (ID +ITMI) not in (SELECT ID +ITmi FROM VENDOR group by ID,ITmi )这条应该可以
考虑是否是由于数据的原因, 特别是对NULL值的处理(SqlServer):select * from TX where isnull(ID,'') +isnull(ITMI,'') not in (SELECT isnull(ID,'') +isnull(ITmi,'') FROM VENDOR group by ID,ITmi )
考虑是否是由于数据的原因, 特别是对NULL值的处理(SqlServer):select * from TX where isnull(ID,'') +isnull(ITMI,'') not in (SELECT isnull(ID,'') +isnull(ITmi,'') FROM VENDOR group by ID,ITmi ) =====================高人啊,果然是这样的,谢谢,也谢谢其他几位朋友
select * from TX where ID +not (ITMI in (SELECT ID +ITmi FROM VENDOR group by ID,ITmi ))
//是这样吧...
select * from TX where (ID +ITMI) not in (SELECT ID +ITmi FROM VENDOR group by ID,ITmi )
我在FORM1建了一个按钮来调用FRAME2怎么不行啊
=====================高人啊,果然是这样的,谢谢,也谢谢其他几位朋友