如何写这个sql语句,用a表中的某一字段对b表中的某一字段进行模糊查找..

Question

WHERE (dbo.GIFTS.GIFT_ID LIKE '%' + dbo.SPONSOR.SPONSOR_ID + '%')

Answer 1

试试:
SELECT dbo.SPONSOR.SPONSOR_ID, dbo.SPONSOR.SPONSOR_NAME, 
      dbo.SPONSOR.ADDRESS, dbo.SPONSOR.TEL, dbo.SPONSOR.SUPERVISOR, 
      dbo.GIFTS.GIFT_ID
FROM dbo.SPONSOR CROSS JOIN
      dbo.GIFTS
WHERE (dbo.GIFTS.GIFT_ID LIKE '%'&    dbo.SPONSOR.SPONSOR_ID & '%')你为什么要用在%前后加空格?

Answer 2

哦,差点忘了.SQL中是用'+'的
SELECT dbo.SPONSOR.SPONSOR_ID, dbo.SPONSOR.SPONSOR_NAME, 
      dbo.SPONSOR.ADDRESS, dbo.SPONSOR.TEL, dbo.SPONSOR.SUPERVISOR, 
      dbo.GIFTS.GIFT_ID
FROM dbo.SPONSOR CROSS JOIN
      dbo.GIFTS
WHERE (dbo.GIFTS.GIFT_ID LIKE '%' + dbo.SPONSOR.SPONSOR_ID + '%')还有,如果你的dbo.SPONSOR.SPONSOR_ID 如果不是字符型的话,就用
SELECT dbo.SPONSOR.SPONSOR_ID, dbo.SPONSOR.SPONSOR_NAME, 
      dbo.SPONSOR.ADDRESS, dbo.SPONSOR.TEL, dbo.SPONSOR.SUPERVISOR, 
      dbo.GIFTS.GIFT_ID
FROM dbo.SPONSOR CROSS JOIN
      dbo.GIFTS
WHERE (dbo.GIFTS.GIFT_ID LIKE '%' + cast(dbo.SPONSOR.SPONSOR_ID as varchar) + '%')

Answer 3

SELECT dbo.SPONSOR.SPONSOR_ID, dbo.SPONSOR.SPONSOR_NAME, 
      dbo.SPONSOR.ADDRESS, dbo.SPONSOR.TEL, dbo.SPONSOR.SUPERVISOR, 
      dbo.GIFTS.GIFT_ID
FROM dbo.SPONSOR CROSS JOIN
      dbo.GIFTS
WHERE (dbo.GIFTS.GIFT_ID LIKE ''%'+cast(dbo.SPONSOR.SPONSOR_ID as varchar)+ '%''')