select  *  from  VW_SF_BRJFXX  A, BM_YGBM00 B where A.JFCZY0 = B.YGBH00 and  A.JKBID0  =  0 
 and  A.JFRQ00 <= '20240307'
 and  A.JFRQ00||A.JFSJ00 <= '2024030718:17:29'
 and  B.ZWXM00||'_'||B.XKH000 = '林素平_l13154'
 and  A.JFJE00  <>  0 
 order by A.JFRQ00 desc,A.JFSJ00 desc