sql ¹ØÓÚ like µÄÒªÇó

SELECT A.UserName, A.UserID, B.UserName, B.UserID 
from  DataBaseA.DBO.ATable A, DataBaseB.dbo.BTable B
WHERE  A.UserID  =  B.UserID

ÎÒÏëÒªµÄÊÇÀàËÆÓÚ£ºA.UserID  like  B.UserID

ÈçºÎд£¿

ÁíÍ⣺ǶÌ×SELECTÓï¾äÖУ¬Ö»ÄÜʹÓà = Âð£¿
SELECT * from A WHERE NN = (SELECT ....)

Ò²Ïë²ÉÓà NN like (SELECT ....) »òÆäËûµÄ in ÈçºÎ£¿

ÒÔ¼° inner join ÖÐÒ²ÊÇÖ»ÄÜʹÓà = Âð£¿

---

ÒýÓÃ

1.
SELECT A.UserName, A.UserID, B.UserName, B.UserID 
from  DataBaseA.DBO.ATable A, DataBaseB.dbo.BTable B
WHERE  cast(A.UserID as varchar)  like  cast(B.UserID as varchar)

2.ǶÌ×SELECTÓï¾äÖУ¬Ê¹ÓÃ"=", ×ÓselectÓï¾äÖ»ÄÜ·µ»ØÒ»¸ö½á¹û¡£Èç¹û¶à¸öµÄ£¬ ¾ÍҪʹÓÃin¡£

``

---

SELECT * from TABLE WHERE NAME LIKE '%ÏþÃ÷%'

---

°´ÉÏÃæ½Ì
select aa,bb from table1 as A ,(select cc from table2) as B
where cast(A.bb as varchar) like %cast(B.cc as varchar)%
´íÎ󣿣¡
µ« where A.bb = B.cc ¾ÍÔËÐÐÕýÈ·£¬ÈçºÎ×ö£¿£¿

---

select * from a,b where cast(b.id as varchar) like '%'+cast(a.id as varchar)+'%'

---

ÒýÓÃ

select * from a,b where cast(b.id as varchar) like '%'+cast(a.id as varchar)+'%'

Ò²²»Ðа¡
{{---