Created
December 18, 2019 21:50
-
-
Save ahmednrana/63d10dcb50656aa931001d40cc5eaec2 to your computer and use it in GitHub Desktop.
Maximo applicationauth from another table
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
MERGE INTO APPLICATIONAUTH TA | |
USING (SELECT GROUPNAME, APP, OPTIONNAME, CONDITIONNUM FROM APPLICATIONAUTH2) AS TB | |
ON (TA.GROUPNAME = TB.GROUPNAME AND TA.APP = TB.APP AND TA.OPTIONNAME = TB.OPTIONNAME AND TA.CONDITIONNUM = TB.CONDITIONNUM) | |
WHEN NOT MATCHED THEN | |
INSERT (APPLICATIONAUTHID, GROUPNAME, APP, OPTIONNAME, CONDITIONNUM) | |
VALUES (NEXTVAL FOR APPLICATIONAUTHSEQ, TB.GROUPNAME, TB.APP, TB.OPTIONNAME, TB.CONDITIONNUM); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment