Problems using SQL Joins

Insights
1

Dear Frappe Insighters, we found a problem using inner joins. The SQL statement is quite easy:

SELECT t0.*
FROM tabEscala TSO AS t0
INNER JOIN tabEscala De Jong Gierveld AS t1
ON t0.owner = t1.owner
LIMIT 500

But the results are quite strange, so the left table is shown but the right table is not…

image
image1460×744 40.9 KB

2

Refer - Table not shown using Inner Join · Issue #129 · frappe/insights · GitHub

1 Like