select sid,id,report_date,hall_name,table_name,people_num,menu_amount,amount,zk_amount,direct_amount 
from SC_RA_Orders 
where sid=4 and zk_amount<>0
union all
select sid,id,report_date,hall_name,table_name,people_num,menu_amount,amount,zk_amount,direct_amount 
from SC_RA_Orders 
where sid=4 and direct_amount>=1