UPDATE Sheet1 S
SET (S.CLT_ID) =
(SELECT DISTINCT(R.CLT_ID)
FROM NTLRESULTS.SOURCE_INGENIO_TBL R
WHERE R.SELLERUSERID = S.SELLERUSERID)
WHERE EXISTS
(SELECT DISTINCT(R.CLT_ID)
FROM NTLRESULTS.SOURCE_INGENIO_TBL R
WHERE R.SELLERUSERID = S.SELLERUSERID);
COMMIT;
when i run this query i am getting syntax error in update statement...
SET (S.CLT_ID) =
(SELECT DISTINCT(R.CLT_ID)
FROM NTLRESULTS.SOURCE_INGENIO_TBL R
WHERE R.SELLERUSERID = S.SELLERUSERID)
WHERE EXISTS
(SELECT DISTINCT(R.CLT_ID)
FROM NTLRESULTS.SOURCE_INGENIO_TBL R
WHERE R.SELLERUSERID = S.SELLERUSERID);
COMMIT;
when i run this query i am getting syntax error in update statement...