SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE |

SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE |

瀏覽:425
日期:2024-04-23
Paul (9): I did it like this: INSERT INTO MRA..T_MRA_MBR (MBR_ID, NCPDP_PRVDR_NUM) SELECT MBR_ID, NCPDP_PRVDR_NUM FROM P350..T_AH_MBR WHERE MBR_ACTV_IND = ‘Y’ AND MBR_ID NOT IN (SELECT MBR_ID FROM MRA..T_MRA_MBR) ......看更多