select t.*,q.objectid,Q.X,Q.Y from sde.hlj_jtl_gcz t,sde.Hlj_Simpl1_Jtl q
where t.线路编码 =substr(q.roadcode,0,4) and substr(q.roadcode,5,6)=substr(t.观测站代码,9,6) and
REPLACE(t.观测站位置,'+','.') > q.startzh and REPLACE(t.观测站位置,'+','.') <= q.endzh
select t.*,q.objectid,Q.X,Q.Y from sde.hlj_jtl_gcz t,sde.Hlj_Simpl1_Jtl q
where t.线路编码 =substr(q.roadcode,0,4) and substr(q.roadcode,5,6)=substr(t.观测站代码,9,6) and
REPLACE(t.观测站位置,'+','.') > q.startzh and REPLACE(t.观测站位置,'+','.') <= q.endzh