SELECT exp_code,exp_spec,units,batch_no,sum(quantity) import_quantity,purchase_price,sum(quantity*purchase_price) import_amount,0 export_quantity,0 export_price,0 export_amount,firm_id,exp_form FROM exp_import_detail,exp_import_master WHERE exp_import_det ail.document_no = exp_import_master.document_no AND exp_import_master.account_indicator = 1 AND exp_import_master.storage='3502' and (exp_import_detail.exp_form= 'all' or 'all'= 'all') AND exp_import_master.import_date >TO_TIMESTAMP('2012-03-23 19:00:00', 'yyyy-mm-dd HH24:MI:SS.FF') AND exp_import_master.import_date >TO_TIMESTAMP('2012-4-25 22:00:00','yyyy-mm-dd HH24:MI:SS.FF') AND exp_import_master.import_date <=TO_TIMESTAMP('2012-4-25 22:00:00','yyyy-mm-dd HH24:MI:SS.FF') GROUP BY exp_code,exp_spec,unit ts,batch_no,purchase_price,firm_id,exp_form