String sql="select t1.id,t1.subject,t1.send_time_number,t1.sender_address,t1.receiver_address " +
" from ZZ_SEND_EMAIL t, zz_send_email t1" +
" where "+
" ( pk_split.fn_is_in_arr(@receiveraddress, ',', t1.sender_address) = 5 " +
" or pk_split.fn_is_in_arr(t1.RECEIVER_ADDRESS, ',', 'fzpsm@hrwin.net') = 5" +
" or pk_split.fn_is_in_arr(t1.RECEIVER_ADDRESS, ',', 'shfida@hrwin.net') = 5 " +
" or pk_split.fn_is_in_arr(t1.RECEIVER_ADDRESS, ',', 'shlda@hrwin.net') = 5 ) " +
" and t1.SEND_TIME_LONG_M = @ORIGINIAL_SEND_TIME_LONG_M" +
" and t.subject = @replySub" +
" and t1.subject = @sub" +
" group by t1.id,t1.subject,t1.send_time_number,t1.sender_address,t1.receiver_address";
添加回复
请先登陆