create or replace view v_jzdshap as
select z.zddm,z.bdcdyh,j.XZBZ,j.YZBZ,z.RKSJ as Gxsj from t_zd z,
(select sde.ST_X(t.shape) AS XZBZ,
SDE.ST_Y(T.SHAPE) AS YZBZ,
t1.jzd_id,
t1.zd_id
FROM st_jzd t,t_zdjzd t1
where t.jzd_id=t1.jzd_id) j
where j.zd_id=z.zd_id;
这个函数是怎么写的,传参不对么?