Kibana Canvas SQL LEFT JOIN WHERE

[timka23 (Dim)]

I want to insert the data in the Kibana Canvas table, but I do not work query.
How to get data using such a request?
SELECT * FROM A LEFT JOIN B ON A.key = B.key

My SQL:
SELECT a.id as idn, COUNT(*) as count, b.title as title
FROM "table_a" AS a
LEFT JOIN
"table_b" AS b
ON a.id=b.id
WHERE a.customer='1'
GROUP BY idn
ORDER BY count DESC
LIMIT 10

[jsanz (Jorge Sanz)]

Hi @timka23, I'm afraid there's no JOIN capability in Elasticsearch SQL. Check the SELECT full documentation for the supported features.

SELECT | Elasticsearch Guide [7.15] | Elastic