i have these two tables.
The first is the users_details table
Second is the users_posts table.
i want to fill the column postedby_name with username from the first column.
I tried a combination of inner join and sub-query but could not do it.
This is the code that i have now.
update users_posts
set users_posts.postedby_name =
(select username from users_details inner join users_posts where
users_posts.postedby = users_details.id);
How to Accomplish this.?