Hello,
I am trying to do this very simple SQL call through through the API:
SELECT table1.col1, table1.col2, table2.col1 FROM table1 INNER JOIN table2 ON table1.col5 = table2.col5 WHERE table1.col4='something'
I am finding this rather difficult, so I tried to create a custom table in Method which links these two tables for me, also didn't work as expected. How can I accomplish this?
Thank you,
Dominic