insert into bj (col1,col2.........) select col1,col2......... from other_tableName where rDate not in (select rDate from bj) update bj set col1=a.col1,col2=a.col2,........ from bj b join other_tableName a on a.rDate=b.rDate
or update bj set col1=a.col1,col2=a.col2,........ from bj b,other_tableName a where a.rDate=b.rDate
insert into bj (col1,col2.........) select col1,col2......... from other_tableName where rDate not in (select rDate from bj)
update bj set col1=a.col1,col2=a.col2,........ from bj b join other_tableName a on a.rDate=b.rDate