Visual Basic SQL Count Query

Hi, I am trying to get the following information, using an Access Database:

sql = "SELECT A.1, A.2, A.3 FROM A"
           
But I also want to get a Count from B Where A.1 = B.1

If I try this:

sql = "SELECT A.1, A.2, A.3, count(B.2) As Number FROM A,B WHERE A.1 = B.1"

I am trying to get a result of all A.1, A.2, A.3 and a count of B.2 where A.1 = B.1

The error I get is:
“you tried to execute a query that does not include the specified expression ‘userName’ as part of an aggregate function"

Any help would be great!

Thanks!
DOCOOGIEAsked:
Who is Participating?
 
TimCotteeConnect With a Mentor Head of Software ServicesCommented:
Hi DOCOOGIE,

You could do:

Select A.1, A.2, A.3, (Select Count(*) From B Where A.1 = B.1) As Number From A

Tim Cottee
Brainbench MVP for Visual Basic
http://www.brainbench.com
0
 
DOCOOGIEAuthor Commented:
Tim,

Thanks!  You are a lifesaver!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.