Yay! A convert!

- I'm going to change that to - "what a small world this is...." - thx. for confirming ...nice to know (at least)...

My 2 cents...I learned from a db design savant many moons ago to name my primary key columns - with an ID suffix and the foreign key columns with an...

Anytime Tarique...I enjoyed the challenge of thinking it out...it was fun!

Yeah really - I enjoy "working" on ssc so much that I have started neglecting my real job - the one that keeps the bread buttered...seriously mean to cut down...

"So there will be a lookup table with all these and the user clicks on the proper button to perform the corresponding action. what do you think of this idea?"...

sound...

...sais pas...call it addiction and lack of control!

I always do Remi...obsessively compulsively so...today is "lack of time"....

GPetc...the only thing you're drawing is attention to yourself....

as for steve....I'm sure he has better things to do with his time - as should we all!(said in my best prim...

Okay fallen angel...let me know if this works:

select A.Region, A.company, A.Department, B.Item1, B.Item2, B.Item3, A.Q1, A.Q2, A.Q3 from

(select Region, Company, Department, SUM(Q1) Q1, SUM(Q2) Q2, SUM(Q3) Q3 FROM TableB

GROUP BY...

David - chalk it up as the reason why you're so smart and savvy today!

off-topic ?! couldn't have done better even if I'd tried...as different from the post that started this as chalk from cheese...

btw...paste and pasta mean the same thing....

amazing sswords...I wasn't kidding when I said I used to eat chalk...I used to LOVE that stuff (calcium deficiency ???) - so GPetc...did you...

steve - that's called a catch-22!!!

Same difference Remi!!!

GPF2^....(wish you had a shorter userID!!) - so my googling was a wild goose chase ?!?! crayons are crayons just as apples are apples...phew! that's a relief!