本文介绍了如何在SQL Server中将AND和JOIN LIKE一起使用?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
先看看这种情况:
我有table1的C1列和2条记录,它们的值分别为Text1和Text2.
I have table1 with column C1 and 2 records in it with values Text1 and Text2.
SELECT * FROM TabelX INNER JOIN table1 ON TableX.Name LIKE '%'+table1.C1+'%'此代码表示:
SELECT * FROM TabelX WHERE TableX.Name LIKE '%Text1%' OR TableX.Name LIKE '%Text2%'现在如何更改JOIN LIKE,即AND而不是OR?像这样:
Now how can I change JOIN LIKE that means AND not OR? Something like:
SELECT * FROM TabelX WHERE TableX.Name LIKE '%Text1%' AND TableX.Name LIKE '%Text2%'推荐答案
我认为这样的方法可以为您服务:
I think something like this can work for you:
BEGIN declare @mycounter integer select @mycounter = count (*) from table1 SELECT * FROM TabelX where @mycounter = (select * from table1 where TableX.Name LIKE '%'+table1.C1+'%') END更多推荐
如何在SQL Server中将AND和JOIN LIKE一起使用?
发布评论