如何检查不等于的条件 [英] How Do I Check Where Condition For Not Equal To

问题描述

亲爱的先生



我如何检查不相同的条件在哪里？



我的代码

 $ q1 =（  SELECT kismispurchase.km_id，kismispurchase .kpm_id，kismispurchase.lot_no as lot_no，kismispurchasemaster.Sdate as sdate from kismispurchase inner join kismispurchasemaster on kismispurchasemaster.kpm_id = kismispurchase.kpm_id and kismispurchase.availableqty！= 0;  

请帮助..

解决方案

q1 =（ SELECT kismispurchase.km_id，kismispurchase.kpm_id，kismispurchase.lot_no as lot_no，kismispurchasemaster.Sdate as sdate from kismispurchase inner join kismispurchasemaster on kismispurchasemaster.kpm_id = kismispurchase.kpm_id and kismispurchase.availableqty ！= 0;

请帮助..

如果kismispurchas e.availableqty包含NULL值，然后以下面的方式写入



isnull（kismispurchase.availableqty，0）<> 0或者isnull（kismispurchase.availableqty，0）！= 0

更改

和kismispurchase.availableqty！= 0 

到

其中kismispurchase.availableqty<> 0 

Dear sir

How do i check not equal conditon for where?

my code

$q1=("SELECT kismispurchase.km_id, kismispurchase.kpm_id,kismispurchase.lot_no as lot_no, kismispurchasemaster.Sdate as sdate FROM kismispurchase inner join kismispurchasemaster on kismispurchasemaster.kpm_id=kismispurchase.kpm_id and where kismispurchase.availableqty!=0;

please help..

解决方案

q1=("SELECT kismispurchase.km_id, kismispurchase.kpm_id,kismispurchase.lot_no as lot_no, kismispurchasemaster.Sdate as sdate FROM kismispurchase inner join kismispurchasemaster on kismispurchasemaster.kpm_id=kismispurchase.kpm_id and where kismispurchase.availableqty!=0;

please help..

if kismispurchase.availableqty contains NULL value also then write in below way

isnull(kismispurchase.availableqty,0) <> 0 or also isnull(kismispurchase.availableqty,0) != 0

change

and where kismispurchase.availableqty!=0

to

where kismispurchase.availableqty <> 0

这篇关于如何检查不等于的条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！