Inner join not working with MySQL select

Grafana Time Series Panel
1

I’ve got below query on Tables “tabStock Ledger Entry” and “tabItem”. When trying to combine I get an error.

SELECT
creation AS “time”,
item_code AS “SKU”,
tabItem.item_code,
actual_qty as metric
FROM tabStock Ledger Entry
INNER JOIN tabItem on tabItem.item_code = SKU
WHERE
$__timeFilter(creation)

This way is working:
SELECT
creation AS “time”,
item_code AS “SKU”,
actual_qty as metric
FROM tabStock Ledger Entry
WHERE
$__timeFilter(creation)

What might be the cause of the query failing?

2

Conseguiu resolver? Estou tendo o mesmo problema aqui quando uso inner com um BD mysql.

3

What is the issue you are having?