看下这个sql怎么写

[jwda7sgr]

4个字段

auit 字段 bool的判断 值1，0
Suppliers 字段 厂家
Suppliers1 字段 厂家1
Suppliers2 字段 厂家2

selet 出 auit=0 并且厂家（Suppliers，Suppliers1，Suppliers2）都有相同值的sql 谢谢啊

[-狙击手-]

select *
from ta
where auit = 0 and suppliers = suppliers1 and suppliers = suppliers2

[华夏小卒]

都有相同值
是什么意思？

[水族杰纶]

--?
select * from tb where auit=0 and Suppliers=Suppliers1 and Suppliers1=Suppliers2

[--小F--]

select 
  * 
from 
  tb 
where 
  auit = 0 and suppliers = suppliers1 and suppliers = suppliers2

[chuifengde]

包含?
SELECT * FROM @a
WHERE audit=0 AND
	CASE WHEN CHARINDEX(S,S1)>0 AND CHARINDEX(S,S2)>0 THEN 1 ELSE 0 END+
	CASE WHEN CHARINDEX(S1,S)>0 AND CHARINDEX(S1,S2)>0 THEN 1 ELSE 0 END+
	CASE WHEN CHARINDEX(S2,S1)>0 AND CHARINDEX(S2,S)>0 THEN 1 ELSE 0 END
	>0

[jwda7sgr]

那个没结果的，就是说 这个sql要满足auit = 0 并且 要满足 suppliers suppliers1 suppliers2
只要出现就查询的到 貌似楼上的想复杂了

[华夏小卒]

select * from tb 
where 
    auit=0 and 
    (suppliers is not null or suppliers1 is not null or suppliers2 is not null ) 


只要出现就查询的到---还是这个意思啊？

[MR丶CHAN]

关注

[zjybushiren88888]

3个字段相同见1,3,4楼.
包含见5楼.
只要一列有值见7楼.