Method Community

 

Simple SQL call

Last post 09-25-2012 8:52 AM by Method_David. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 09-22-2012 11:27 AM

    Simple SQL call

    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

  • 09-25-2012 8:52 AM In reply to

    Re: Simple SQL call

    Answer


    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

Page 1 of 1 (2 items)