..so pick up that gauntlet then...

I'll refrain from commenting on your beliefs Mike...with your high morals I doubt that "fun" would have any part...

............

Alright...you hang on to them morals...

Why don't you hack it so that I'm on top...I'll try and get my fun other ways....

sigh - as always don't know whether to thank you or to rail at you Mike....I look at my personal best which's been 407665 and I wait for the leaderboard...

Ron - you must've read my mind...have been meaning to ask Mike this for some time now...and of course now it's (almost) too late...

Isa - I'm not completely sure I understand your question...but if it is what I think it is then you need to capture the user selection into variables....pass those variables...

something like this probably....cannot test...

select G.GroupCode, sum(G.amount)+ max(L.amount) as totalAmount
from MGroup G
inner join 
(select GroupCode, sum(amount) as amount from MLedger group by Groupcode)L 
on
G.GroupCode = L.GroupCode
group by G.GroupCode

Please do not post in multiple forums...

Follow the thread here

select fruit, username

from fruits

inner join

users on

fruits.access = users.group

order by fruit

looking for a software expert who speaks German for problems with English software and the English language...

take a survey and you may win one...

Well Remi - can't you be like the mechanic who fixes a flat tyre without actually seeing the car ?! I thought you were a wiz!!!

well..this is a job for the client!

also..grouping by addresses is fraught with pitfalls..you should look for some other column/candidate to group on!!!

...me too...thought it was a change from the usual mailman ones...

To those like maddog...my deepest sympathy!

My goal has been (for the last 10 yrs or so..) to spend each New Years' eve in a different country...so this year it's back...

James - could you pl. post the actual query sent when the ID filter is applied !

Also, when you say that the query works "fine by itself" you mean in...