-- INSERT with qualified star source
INSERT INTO BMRT.REG_DEAL (ID_DEAL, DEAL_NUMB)
SELECT RS.* FROM BMRT_META.REG_DEAL RS
JOIN BMRT.DEAL D ON RS.ID=D.ID AND D.DT_FROM=SYSDATE;
