查询时,发现org_id 为number类型,zone_id为varchar2类型,需要转化 转换 to_char(),或者to_numberselect a.id,b.col,a.col from a,b where to_char(a.id)= b.id 转载于:https://www.cnblogs.com/bingyublog/p/7809348.html