SQL query: 
UPDATE term_node AS tn SET tn.tid = tmp2_terms.mintid WHERE tn.tid = tmp2_terms.tid AND tn.vid =1 
MySQL said: Documentation 
 #1054 - Unknown column 'tmp2_terms.tid' in 'where clause' 

term_node
Field     Type     Null    Default
nid       int(10)   No      0    
tid       int(10)   No      0 

tmp2_terms
Field          Type          Null Default
tid            int(10)       No   0    
vid            int(10)       No   0    
name           varchar(255)  No       
description    longtext      Yes   NULL    
weight         tinyint(4)    No   0    
mintid         int(10)       Yes   NULL