I have a query like below but its syntax is not accepted by Cache.
I would like to perform a left join on two tables first and then make a inner for this result with another table.
Given the constraint that we only allow one SELECT in the query, it is possible to achieve this semantics ?
Thank for your help.
FROM ( sample . employee e
LEFT JOIN sample . company c
on c . id = e . id ) g
JOIN sample . vendor v
on v . %id = g . attr