table A
cid dep arn
1 bos sti
2 ahi jkl
3 nam man
4 bos sti
table B
ori des pos
bos,can,cha,chi sti,sar 10
bos,ahi,cnm jkl,lan 15
aca,yhu,bbs jkh,nan,kel,shu 12
请从table A 中找出dep包含在tableB.ori中,并且arn包含在 tableB.des中的pos值,得到如下结果.谢谢
cid dep arn pos
1 bos sti 10
2 ahi jkl 15
3 nam man null
4 bos sti 10
沙发 先做起
SQL code:
select a.*,b.pos
from a
left join b
on charindex(','+a.dep+',',','+b.des+',')>0
select a.*,b.pos
from a
left join b
on charindex(','+a.dep+',',','+b.ori+',')>0
SQL code:
----------------------------------------------------------------
-- Author :fredrickhu(小F，向高手学习)
-- Date :2010-04-21 08:22:09
-- Verstion:
-- Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86)
--
