Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

UNION question [message #3207] Thu, 19 June 2008 19:02  rmarshsj Messages: 1 Registered: June 2008 Junior Member Hi All, I am creating a temporary table which is the union of three selects each producing an ID and a score. If I use UNION on its own I lose any duplicated rows. If I use UNION ALL I get some rows with the same ID but different scores. What I want instead is to end up with unique IDs with the score column being the sum of the scores for any duplicate rows. Is this possible? Does anyone have any suggestions? Thank you, Rob Report message to a moderator

UNION question By: rmarshsj on Thu, 19 June 2008 19:02

Previous Topic:	Call sql script from sql script
Next Topic:	Help Me optimize my query

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]