Hi, yes sorry, please try ----- UPDATE tx_news_domain_model_file SET parent=(SELECT `uid` FROM `tx_news_domain_model_news` WHERE related_files=tx_news_domain_model_file.uid) ------- thx for feedback georg