重复值查询

最新推荐文章于 2023-01-16 17:25:58 发布

雁过留香

最新推荐文章于 2023-01-16 17:25:58 发布

阅读量136

点赞数

分类专栏： SQL查询

本文链接：https://blog.csdn.net/qq_41969460/article/details/88311633

版权

SQL查询专栏收录该内容

5 篇文章 0 订阅

订阅专栏

--select t1.FName from icbom a
--inner join icbomchild b on a.FinterID = b.FinterID
--inner join t_icitem t1 on a.FitemID = t1.FitemID
--inner join t_icitem t2 on b.FitemID = t2.FitemID
--where (t2.FName like '%单瓦小盒8*8%' or t2.FName like '%蛋壳%')
--
--group by t1.FName
--having count(*) >1

select t1.FName,t2.FName from icbom a
inner join icbomchild b on a.FinterID = b.FinterID
inner join t_icitem t1 on a.FitemID = t1.FitemID
inner join t_icitem t2 on b.FitemID = t2.FitemID
where (t2.FName like '%单瓦小盒8*8%' or t2.FName like '%蛋壳%')
and t1.FName in ('81439H-2包装','81439H包装','3866H包装','81439H-1包装','81353H-1包装','81385H包装')