Here is the query I am using:
UPDATE patron FROM DB1.PATRON patron, (SELECT * FROM DB1.PatronLN_NoHmac_14p_435 AS tmp INNER JOIN DB2.PATRON pat ON pat.Patron_ID = tmp.TM_Patron_id)AS patron_TM SET Term1 = patron_TM.Term1,Term2 = patron_TM.Term2,Term3 = patron_TM.Term3,Timestamp_val = CURRENT_TIMESTAMP(0)WHERE patron.id1 = patron_TM.id2 AND patron.ident = 'AB' AND patron.Term1 IS NULL ;
And here is the error:
UPDATE failed.  Alias name defined should be used instead of table name patron.
I think I am using correct alias values here. Please help.
This is TD15 btw.
Thanks in advance
Solved! Go to Solution.