А простой вариант через exists или in (select ...) вместо inner join не подойдет?
select posts.* from posts where id in (select j_id from follows where u_id = 1)
или
select posts.* from posts where exists (select j_id from follows where u_id = 1 and posts.id = j_id)