Any way I can do this? Should I do this?

B

Bob Barrows

Jeff said:
GOT IT!! All is well. Changed COUNT(*) to COUNT(l.Cat_Id). Thanks
Bob for your input, help guidance, and for all around being a nice
guy!

Glad to hear it!

I hope you now see the point of creating a tabular representaion of your
desired results. Not only does it help convey the requirements to somebody
else, it also may help you solve the problem yourself by forcing you to see
the output the way the query engine would.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,770
Messages
2,569,584
Members
45,075
Latest member
MakersCBDBloodSupport

Latest Threads

Top