Use LEFT OUTER JOIN

LEFT JOIN contacts ;

>With the following SELECT STATEMENT:

>SELECT courses.ctitle,students.clastname,agencies.cagencyname,contacts.ccontact ;
>   FROM courses ;
>   JOIN students ;
>      ON students.icourseid = courses.iid ;
>   JOIN agencies ;
>      ON agencies.iid = students.iagencyid ;
>   JOIN contacts ;
>      ON contacts.iid = students.icontactid ;
>   WHERE courses.iid = 1 ;
>   ORDER BY students.clastname

>If students.icontactid is empty, no record is returned at all. How do I get a record to be returned with an empty value for contacts.ccontact?
>
>Thanks in advance!
>
>Steve