Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Little blank boxes in lieu of field?

Status
Not open for further replies.

danpatch

Technical User
Dec 3, 2000
2
US
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;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top