Does anybody have an idea why my 3-column grouped query might be returning a last row containing one small check-type box (without a check)? When I turn grouping off the column (a text field) returns correctly, but with grouping on I get these strange boxes.
Any help would be appreciated. The two SQL statements (ungrouped and grouped) are set forth below:
Ungrouped:
SELECT Tracking.SAID, Tracking.ViewDate, SubscriberArticles.Title
FROM Tracking INNER JOIN SubscriberArticles ON Tracking.SAID = SubscriberArticles.ID;
Grouped:
SELECT Tracking.SAID, Tracking.ViewDate, SubscriberArticles.Title
FROM Tracking INNER JOIN SubscriberArticles ON Tracking.SAID = SubscriberArticles.ID
GROUP BY Tracking.SAID, Tracking.ViewDate, SubscriberArticles.Title;
Any help would be appreciated. The two SQL statements (ungrouped and grouped) are set forth below:
Ungrouped:
SELECT Tracking.SAID, Tracking.ViewDate, SubscriberArticles.Title
FROM Tracking INNER JOIN SubscriberArticles ON Tracking.SAID = SubscriberArticles.ID;
Grouped:
SELECT Tracking.SAID, Tracking.ViewDate, SubscriberArticles.Title
FROM Tracking INNER JOIN SubscriberArticles ON Tracking.SAID = SubscriberArticles.ID
GROUP BY Tracking.SAID, Tracking.ViewDate, SubscriberArticles.Title;