The reason I think it is date format is because, I ran this query below. It is essentially the same query. Just updating INDEX_ID which is a text data type instead of date. This one works fine. All the INDEX-ID got updated as expected-wherever there is a match of simple_id in both tables. update work.INVENTORY_COPY as u set INDEX_ID = (select INDEX_ID from WORK.CONFIG_BACKFILL as n where u.SIMPLE_ID=n.SIMPLE_ID);
... View more