updating two tables with inner join where there is no relation(PK,FK) between those table.

See more:

PostgreSQL

update Claim set first_name = random_name(7),
Last_name = random_name(6),
t2.first_name=random_name(7),
t2.last_name=random_name(6)

from Claim t1
inner join ecpremit t2
on t1.first_name = t2.first_name

Error i am getiing when i run above query.

column "t2" of relation "claim" does not exist