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.