select hmv.hy_time_stamp, mm.cu_name , mm.meter_number
from (select hc.hy_name_last as cu_name,hm.hy_meter_number as meter_number
from hy_customer hc,hy_metainfo_customer hmc, hy_meter_point hmp ,hy_metainfo_meter hmm ,hy_meter hm
where hc.hy_storage_id = hmc.hy_meta_id
and hmc.hy_meter_point_id = hmp.hy_storage_id
and hmp.hy_storage_id = hmm.hy_meter_point_id
and hmm.hy_meta_id = hm.hy_storage_id and hm.hy_meter_number = '12144549') mm
,hy_meas_line hml, hy_meas_val hmv,hy_meter_point hmp
,hy_metainfo_meter hmm ,hy_meter hm
where hml.hy_meter_point_id = hmp.hy_storage_id and hmp.hy_storage_id = hmm.hy_meter_point_id
and hmm.hy_meta_id = hm.hy_storage_id
and hml.hy_storage_id = hmv.hy_meas_line_id and hmv.hy_semantic_id = 'volume.main'
and hmv.hy_time_stamp < Add_months(sysdate,-1) order by hmv.hy_time_stamp;
这是我在数据库中写的一个查询。。用到了子表等等。。想写成存储过程,最后在netbeans中调用这个,获得这三个数据,,怎么整?