I am trying to update one table with a value from another table and continue getting the above error. i am using phpmyadmin

the 2 tables i have are as follows
Table 1
wp_posts

fields
post_id
posts_title

Table 2
wp_postmeta

fields
post_id
meta_key
meta_value

I am trying to get the value from post_title to meta_value
using the following sql statement

UPDATE`wp_postmeta` SET `meta_value` = concat('MSP Studio Photographer - ',`wp_posts`.`post_title`) WHERE `wp_postmeta`.`meta_key`='_aioseop_title' and `wp_postmeta`.`post_id`= `wp_posts`.`post_id`;

It shows that the column post_id does not exist in the table wp_post, are you sure that is true or not?

Yes I have double checked the spelling and existance of the column, definately there in the table.

Remove the "backticks".