select a.* from veh_flow a,s_ywlx@zzjj b where a.lsh not in (select s_vehsfjl.ywlsh from s_vehsfjl@zzjj) and a.ywlx=b.ywlx and a.ywyy=b.ywyy and instr(b.ywzldm,a.hpzl)>0 and b.ywxtdm='01' and b.yesno=1 and b.xmdm in (select s_xmdzb.sfxmdm from s_xmdzb@zzjj where s_xmdzb.userid='0002') and rownum<30 order by a.lsh asc
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货