本帖最后由 Lenka.Guo 于 2016-6-27 10:23 编辑
ch.id cht.id为整形,如何支持整形参数?
select type,sample_id,id_text,sample_name,sample_type,sampled_date,product_id,sampling_point,u_standard,u_memo,coa_date,coa_p_name,
analysis,analysis_desc,u_analysis,result_name,result_text,result_units,u_description ,r_on_spec,r_level_name,order_num
from (
select 'N' as type, ch.sample_id,ch.id_text,ch.sample_name,ch.sample_type,ch.sampled_date,ch.product_id,ch.sampling_point,ch.u_standard,ch.u_memo,ch.coa_date,ch.coa_p_name,
cr.analysis,cr.analysis_desc,cr.u_analysis,cr.result_name,cr.result_text,cr.result_units,cr.u_description ,cr.r_on_spec,cr.r_level_name,cr.order_num
from COA_HEADER ch,COA_RECORD cr where ch.id=cr.header_id and ch.id = <%headerid%>
union
select 'T' as type, cht.sample_id,cht.id_text,cht.sample_name,cht.sample_type,cht.sampled_date,cht.product_id,cht.sampling_point,cht.u_standard,cht.u_memo,cht.coa_date,cht.coa_p_name,
crt.analysis,crt.analysis_desc,crt.u_analysis,crt.result_name,crt.result_text,crt.result_units,crt.u_description ,crt.r_on_spec,crt.r_level_name,crt.order_num
from COA_HEADER_temp cht,COA_RECORD_temp crt where cht.id=crt.header_id and cht.id= <%headerid%>)
where type='<%type_id%>' order by order_num
|
|