When using either <code>chunkById</code> or <code>lazyById</code> with Laravel's query builder you must pass an additional parameter to avoid the error <code>SQLSTATE[42702]: Ambiguous column: 7 ERROR: column reference "id" is ambiguous</code>.
lazyById:
<pre><code>User::join('posts', 'posts.user_id', 'users.id)
 -&gt;lazyById(100, 'users.id', 'id')
 -&gt;each(function ($user) {
 // do work
 });
</code></pre>chunkById:
<pre><code>User::join('posts', 'posts.user_id', 'users.id)
 -&gt;chunkById(100, function ($user) {
 // do work
 }, 'users.id', 'id')
</code></pre>

When using either `chunkById` or `lazyById` with Laravel's query builder you must pass an additional parameter to avoid the error `SQLSTATE[42702]: Ambiguous column: 7 ERROR: column reference "id" is ambiguous`.

**lazyById**:
```
User::join('posts', 'posts.user_id', 'users.id)
     ->lazyById(100, 'users.id', 'id')
     ->each(function ($user) {
          // do work
     });
```

**chunkById**:
```
User::join('posts', 'posts.user_id', 'users.id)
     ->chunkById(100, function ($user) {
          // do work
     }, 'users.id', 'id')
```



Laravel & PHP by Guy Warner

Laravel & PHP by Guy Warner

How to fix Integrity constraint violation in Laravel chunkById and lazyById