Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
idb65
Starting Member
4 Posts |
Posted - 2013-04-30 : 17:37:35
|
Hello my friendsi have these to tablescountry: country_code,populationis_member: organization,country_codenow i want name of organizations with the sum of the population of their members countriesi wrote this but i think it is not correctselec mem.organization,sum(co.population)from country cojoin is_member memon co.country_code=mem.country_code;thank u so much for ur helpI use oracle 11gbest |
|
singularity
Posting Yak Master
153 Posts |
Posted - 2013-04-30 : 20:41:21
|
[code]select mem.organization,sum(co.population)from country cojoin is_member memon co.country_code=mem.country_codegroup by mem.organization;[/code] |
|
|
idb65
Starting Member
4 Posts |
Posted - 2013-05-01 : 03:13:57
|
Thank you so much.quote: Originally posted by singularity
select mem.organization,sum(co.population)from country cojoin is_member memon co.country_code=mem.country_codegroup by mem.organization;
|
|
|
|
|
|