select a.labour_cost, job_REF_CODE, WORK_ORDER_CODE, SITE_INSTRUCTION_NBR, WORK_DESC, JOB_LOCATION from job_order, ( Select q.labour_cost From quote_summary q,job_order j Where q.bus_unit_code=j.bus_unit_code And q.job_order_id=j.job_order_id And q.status='S' And rownum <= 1) ) a
(
Select q.labour_cost From quote_summary q,job_order j
Where q.bus_unit_code=j.bus_unit_code And q.job_order_id=j.job_order_id
And q.status='S' And rownum <= 1)
) a
然后用
@c:\test.sql行波