# ES-SQL UNION alternative \[Was: Sql query canvas\] **URL:** \ **Category:** Elasticsearch\ **Created:** [December 1, 2021, 7:58am UTC](https://discuss.elastic.co/t/es-sql-union-alternative-was-sql-query-canvas/290637 "2021-12-01T07:58:30Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![asmaalqasem4](https://avatars.discourse-cdn.com/v4/letter/a/6de8d8/32.png) [@asmaalqasem4](https://discuss.elastic.co/u/asmaalqasem4)\ **Post date:** [December 1, 2021, 7:58am UTC](https://discuss.elastic.co/t/es-sql-union-alternative-was-sql-query-canvas/290637/1 "2021-12-01T07:58:30Z")
Hello,, I need to implement this query in the canvas but it is not working. is there another way to get the same result? - _SELECT SUM(amount) \*\* \*FROM (SELECT AMOUNT as amount FROM "payment-index "\*_ - _UNION \*\* \*SELECT PaindAmount as amount FROM "ssk-index ")\*_ thanks, ---
**Author:** ![majagrubic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/majagrubic/32/74459_2.png) [@majagrubic](https://discuss.elastic.co/u/majagrubic)\ **Post date:** [December 1, 2021, 9:58am UTC](https://discuss.elastic.co/t/es-sql-union-alternative-was-sql-query-canvas/290637/2 "2021-12-01T09:58:29Z")
Hi, could you provide a bit more info into what's not working exactly and how does your data look like? ---
**Author:** ![asmaalqasem4](https://avatars.discourse-cdn.com/v4/letter/a/6de8d8/32.png) [@asmaalqasem4](https://discuss.elastic.co/u/asmaalqasem4)\ **Post date:** [December 1, 2021, 10:12am UTC](https://discuss.elastic.co/t/es-sql-union-alternative-was-sql-query-canvas/290637/3 "2021-12-01T10:12:29Z")
I have two different indices with two different fields, i want to add them together and view it in the dashboard, i tried to it by dashboard but it is not possible.. now i am trying to use canvas to make this ---
**Author:** ![majagrubic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/majagrubic/32/74459_2.png) [@majagrubic](https://discuss.elastic.co/u/majagrubic)\ **Post date:** [December 1, 2021, 10:15am UTC](https://discuss.elastic.co/t/es-sql-union-alternative-was-sql-query-canvas/290637/4 "2021-12-01T10:15:08Z")
And what is the error that you're getting with the current query? ---
**Author:** ![asmaalqasem4](https://avatars.discourse-cdn.com/v4/letter/a/6de8d8/32.png) [@asmaalqasem4](https://discuss.elastic.co/u/asmaalqasem4)\ **Post date:** [December 1, 2021, 10:53am UTC](https://discuss.elastic.co/t/es-sql-union-alternative-was-sql-query-canvas/290637/5 "2021-12-01T10:53:03Z")
![image](https://us1.discourse-cdn.com/elastic/original/3X/0/b/0b5f15c5d252570e338c7fc315118b4d9d1210f8.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/f/0f0fccbb95d820e8cc7e1505ad245c40e8a5822d.png) this is what i get when i run the query ---
**Author:** ![majagrubic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/majagrubic/32/74459_2.png) [@majagrubic](https://discuss.elastic.co/u/majagrubic)\ **Post date:** [December 1, 2021, 1:21pm UTC](https://discuss.elastic.co/t/es-sql-union-alternative-was-sql-query-canvas/290637/6 "2021-12-01T13:21:35Z")
I think `UNION` is not supported by the ES SQL, according to the docs [here](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-lexical-structure.html). ---
**Author:** ![asmaalqasem4](https://avatars.discourse-cdn.com/v4/letter/a/6de8d8/32.png) [@asmaalqasem4](https://discuss.elastic.co/u/asmaalqasem4)\ **Post date:** [December 1, 2021, 1:34pm UTC](https://discuss.elastic.co/t/es-sql-union-alternative-was-sql-query-canvas/290637/7 "2021-12-01T13:34:34Z")
what can i use instead of union? ---
**Author:** ![majagrubic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/majagrubic/32/74459_2.png) [@majagrubic](https://discuss.elastic.co/u/majagrubic)\ **Post date:** [December 1, 2021, 4:44pm UTC](https://discuss.elastic.co/t/es-sql-union-alternative-was-sql-query-canvas/290637/8 "2021-12-01T16:44:04Z")
I will transfer this question to ES forum, as they might be able to help further. In the meantime, this is an [issue](https://github.com/elastic/elasticsearch/issues/34414) to help you track support for UNION. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [December 29, 2021, 4:44pm UTC](https://discuss.elastic.co/t/es-sql-union-alternative-was-sql-query-canvas/290637/9 "2021-12-29T16:44:41Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.