select cwh ,aa from table1
结果:
cwh aa
--------------------- d001 ''
d002 ''
d003 ''select jbh from table2
结果:
jbh
--------------------- 11001
11002
11003 如何用这两个表,使结果变成
cwh aa jbh
--------------------- d001 '' 11001
d002 '' 11002
d003 '' 11003
结果:
cwh aa
--------------------- d001 ''
d002 ''
d003 ''select jbh from table2
结果:
jbh
--------------------- 11001
11002
11003 如何用这两个表,使结果变成
cwh aa jbh
--------------------- d001 '' 11001
d002 '' 11002
d003 '' 11003
where right(a.cwh,3) = right(convert(varchar(20),b.jbh),3)
from table1 a
left join table2 b
on substring(a.cwh,len(rtrim(a.cwh))-3,3)=substring(b.jbh,len(rtrim(b.jbh))-3,3)
from table1 a,table2 b
where substr(a.cwh,2,3) = substr(b.jbh,3,3)