Hi, i have two tables, but not all of the fields are joined...<BR>Is there any way to get all of the fields, the ones joined and the ones not joined, and in the case they are not joined i just want the joined fields to be empty.<BR><BR>I mean if i have a table of children, and one of children_activities, and not all of the children have activites, the children_activites table has 3 fields: activity_id, activity_name and activity_teacher.<BR><BR>so in my sql i want to have all of the fields where the children have activities and those who don&#039;t, and in the ones they dont i just want to fields of children_activites to be empty.<BR><BR>Thanks.