Than you Barrad. Unfortunately this hasnt worked for me. using:
SELECT activityName, activityVenue, activityStart, signupActivitychildID, signupActivityStatus
FROM activities
LEFT JOIN
signupActivity ON activityID = SignupActivityID
LEFT JOIN
children ON signupActivitychildID = childrenID AND signupActivitychildID = 33
WHERE activitySection = 3
has given me the result for every record in the signupActivity database related to an activity with activitySection = 3 however I dont get NULL values for the activities that child 33 hasn't signed upto