# SQL plugin offset not working

**URL:** <https://forum.opensearch.org/t/sql-plugin-offset-not-working/12215>\
**Category:** SQL\
**Created:** [January 20, 2023, 9:59pm UTC](https://forum.opensearch.org/t/sql-plugin-offset-not-working/12215 "2023-01-20T21:59:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![naimi\_92](https://avatars.discourse-cdn.com/v4/letter/n/eada6e/32.png) [@naimi\_92](https://forum.opensearch.org/u/naimi_92)\
**Post date:** [January 20, 2023, 9:59pm UTC](https://forum.opensearch.org/t/sql-plugin-offset-not-working/12215/1 "2023-01-20T21:59:45Z")

</div>

**Versions** (relevant - OpenSearch/Dashboard/Server OS/Browser):

**Describe the issue** :  
Hi  
I use opensearch and I have two indices `transaction` and `users`  
when I creating inner join the offset not working but limit works

**Configuration** :

**Relevant Logs or Screenshots** :

---

<div class="post-metadata">

**Author:** ![andrewc](https://avatars.discourse-cdn.com/v4/letter/a/e95f7d/32.png) [@andrewc](https://forum.opensearch.org/u/andrewc)\
**Post date:** [February 9, 2023, 9:18pm UTC](https://forum.opensearch.org/t/sql-plugin-offset-not-working/12215/2 "2023-02-09T21:18:09Z")

</div>

Because of the nature of OpenSearch, support for JOINs and limits/pagination is still pending.

see: [Limitations - OpenSearch documentation](https://opensearch.org/docs/latest/search-plugins/sql/limitation/#pagination-only-supports-basic-queries)
