Method Community

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

Hi Dominic Riccetti,

We don't allow table join queries via the API. I'll put in a suggestion about allowing this in the future.

To accomplish what you are trying to do you need to link the tables first and then query the resulting table via the API.

I'm gonna point you at the following http://www.methodintegration.com/cs/forums/p/381/1191.aspx#1191 and http://www.methodintegration.com/cs/forums/p/3321/12712.aspx#12712 both posts discuss the linking process

Dave