Hi,
cast ??????????
??1??DEPARTMENTCLASS
??2??table2
DEPARTMENTCLASS.DEPARTMENTCLASSID  ?? int ????
table2.FDIMID ??varchar????


??join????????????????
select
...
inner join
...
on CAST(DEPARTMENTCLASS.DEPARTMENTCLASSID AS VARCHAR(20))= table2.FDIMID
??????
on CAST(DEPARTMENTCLASS.DEPARTMENTCLASSID AS VARCHAR(20))= on 
CAST(table2.FDIMID  AS VARCHAR(20))
????????????




??sql??????mysql??????????????????????


??????????????????
????????

Reply via email to