1 2 Previous Next 17 Replies Latest reply on Jan 7, 2010 3:49 PM by nateborland

    ODBC Query - COUNT and GROUP BY Producing Unfavorable results

    nateborland

      Title

      ODBC Query - COUNT and GROUP BY Producing Unfavorable results

      Your post

      The issues with FileMaker's ODBC abilities are starting to get REALLY frustrating. For a product that heralded its great integration abilities, I'm very disappointed. Here's another issue..

       

      SELECT DISTINCT "Company", COUNT (*) AS agg FROM Audits
      WHERE "DateReviewed" > '6/1/2009'
      GROUP BY "Company"

       

      When running this query, I get return values that are completely invalid.The first indicator of this is that the same company (even though there is a GROUP BY constraint) is listed multiple times. Any ideas?

        1 2 Previous Next