查询时,发现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