By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,453 Members | 937 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,453 IT Pros & Developers. It's quick & easy.

I keep getting an error in this sql statement

P: 3
Expand|Select|Wrap|Line Numbers
  1. SELECT   TwoItemBasket . FirstItem,
  2.          TwoItemBasket . SecondIte,
  3.          Count (*) As SupportCount
  4. FROM     TwoItemBasket
  5. GROUP BY TwoItemBasket.FirstItem,
  6.          TwoItemBasket.SecondItem;
Jul 20 '10 #1
Share this Question
Share on Google+
3 Replies


100+
P: 255
Maybe some spacing problem in the select part, try it like this.
Expand|Select|Wrap|Line Numbers
  1. SELECT TwoItemBasket.FirstItem,
  2. TwoItemBasket.SecondIte,
  3. (Count(*)) As SupportCount
  4. FROM TwoItemBasket
  5. GROUP BY TwoItemBasket.FirstItem,
  6. TwoItemBasket.SecondItem;
  7.  
Jul 20 '10 #2

P: 3
@colintis
Tried it, the error is coming from that last line
Jul 20 '10 #3

100+
P: 255
@emmebanx
I just re-read the code, the select item2 is misspelled.

TwoItemBasket.SecondIte, and
TwoItemBasket.SecondItem,
Jul 20 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.