SQLite Forum

"ON clause references tables to its right"
Login
Found the error message in sqlite.c lines [145646-145650]

```
/* ON clause terms may not be used with an index
                       ** on left table of a LEFT JOIN.  Ticket #3015 */
    if( (prereqAll>>1)>=x ){
      sqlite3ErrorMsg(pParse, "ON clause references tables to its right");
      return;
```