Hi I am a bit rusty with SQL, not used it for about 8 years so would appreciate a bit of help.
I have three tables, normalised,
organisation, stores org_name and org_id
ativities stores activity_name and ativity_id
org_activity stores org_id and activity_id
I need to get a list that contains each organisation name distinctly along with a list of all the activities associated with it. Try as I might I just can't get my head round it, any pointers would be greatfully received.
Thanks
Julie
Jump to PostMysql has a nifty function for it: group_concat
Like inselect org_name, group_concat(activity_name) from organisation o, activities a, org_activity oa where o.org_id=oa.org_id and oa.activity_id=a.activity_id group by o.org_id ;(Code not tested)
Alternatively you may look at the various JOIN syntax varieties of MySQL.
Mysql has a nifty function for it: group_concat
Like in
select org_name, group_concat(activity_name)
from organisation o, activities a, org_activity oa
where o.org_id=oa.org_id
and oa.activity_id=a.activity_id
group by o.org_id
;(Code not tested)
Alternatively you may look at the various JOIN syntax varieties of MySQL.
Wow thanks a million, I have never come across group_concat and it does the trick.
Thanks you so much for all your help
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.