clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 995120 fiddles created (10948 in the last week).

create table "Products" ( id int, price int, factor1 int, factor2 int ); create table "Article" ( id int, factor1 int, factor2 int );
 hidden batch(es)


UPDATE Products SET factor1 = (SELECT factor1 FROM Article WHERE Article.id = Products.id) WHERE EXISTS (SELECT factor1 FROM Article WHERE Article.factor1 = Products.id)
ERROR: relation "products" does not exist LINE 1: UPDATE Products ^
 hidden batch(es)