On Fri, Jan 23, 2015 at 11:52 AM, dealTek <dealtek@xxxxxxxxx> wrote: > > On Jan 22, 2015, at 5:50 PM, dealTek <dealtek@xxxxxxxxx> wrote: > > > > > ... I needed to do two separate queries to the same mysql contacts table > (rather than one more elegant combined one) > > > > > > Hi folks, > > I stated something incorrect (late night last night) - I said mysql table > but in fact this is using filemaker backend and I don't believe that I can > do complex php queries with filemaker as described - so I was going to just > do 2 different queries and combine them... hope that helps > > It looks like FileMaker 12 does allow more complex queries: http://filemakerhacks.com/2012/10/19/the-missing-fm-12-executesql-reference/ It looks like It's a pretty standard SQL query, now. Build the SELECT statement, then use ExecuteSQL() to run it. Andy
