AnsweredAssumed Answered

ODBC Query - COUNT and GROUP BY Producing Unfavorable results

Question asked by nateborland on Jul 30, 2009
Latest reply on Jan 7, 2010 by 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?

Outcomes