你看一下，billion应该有非数字的内容转成字符进行比较 select * from A,B where to_char(A.CourseNum)=B.billon;
select * from A,B where TO_CHAR(A.CourseNum) =B.billon
