I keep getting an error in this sql statement

[emmebanx]

SELECT   TwoItemBasket . FirstItem,
         TwoItemBasket . SecondIte,
         Count (*) As SupportCount
FROM     TwoItemBasket
GROUP BY TwoItemBasket.FirstItem,
         TwoItemBasket.SecondItem;

[colintis]

Maybe some spacing problem in the select part, try it like this.

SELECT TwoItemBasket.FirstItem,
TwoItemBasket.SecondIte,
(Count(*)) As SupportCount
FROM TwoItemBasket
GROUP BY TwoItemBasket.FirstItem,
TwoItemBasket.SecondItem;

[emmebanx]

Maybe some spacing problem in the select part, try it like this.

SELECT TwoItemBasket.FirstItem,
TwoItemBasket.SecondIte,
(Count(*)) As SupportCount
FROM TwoItemBasket
GROUP BY TwoItemBasket.FirstItem,
TwoItemBasket.SecondItem;

Tried it, the error is coming from that last line

[colintis]

Tried it, the error is coming from that last line

I just re-read the code, the select item2 is misspelled.

TwoItemBasket.SecondIte, and
TwoItemBasket.SecondItem,