ODBC Query - COUNT and GROUP BY Producing Unfavorable results
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?