Re: hoping someone is up!

2008-10-01 Thread denstar
On Wed, Oct 1, 2008 at 10:14 AM, Torrent Girl wrote: > Anyone, soomeone, help please It's not as fun as one big solution, but you could break it up into smaller chunks, and put those chunks together. Sometimes that's fastest, even if it's not the most efficient. Sorry no instant "ah ha!" when lo

Re: hoping someone is up!

2008-10-01 Thread Ian Skinner
It sounds like you are going to need to look at your join syntax. Since you are join your users to courses you are going to get 9 records for that one user. Then when you sum those up you are going to get nine!. But I am unclear on what to do about it. One would need to know a lot more your d

Re: hoping someone is up!

2008-10-01 Thread Torrent Girl
Anyone, soomeone, help please >hello all > >I tried my hardest to figure this one out by myself, but here goes. > >I have a query that returns sums of a few columns. I need to count the number >of >people with certain occupations and count the number of classes they took by a >certain course

hoping someone is up!

2008-09-30 Thread Torrent Girl
hello all I tried my hardest to figure this one out by myself, but here goes. I have a query that returns sums of a few columns. I need to count the number of people with certain occupations and count the number of classes they took by a certain course ID. The problem is there are only 4 peop