Essentially I want to write a request

SELECT * FROM 'threads' INNER JOIN 'users' ON 'threads.author_id' = 'users.id'

But my option

$threads = $query->join('INNER JOIN', 'users', 'users.id = threads.author_id') ->orderBy('thread_id') ->offset($pagination->offset) ->limit($pagination->limit) ->all();

For some reason, it displays only a part of the Threads table. What could be the problem?

    1 answer 1

      ->innerJoin('users', 'threads.author_id'='users.id')