I'm writing query to select students with their Program, Country and Teacher. So far, I have the following query: Please see the attachment for the SQL. I wrote them here but could not submit. It always says "Oops! your Post seems to be a SPAM!..." Can anyone check why I cannot submit such query? These two columns H.TEACHER_CODE and H.COUNTRY_CODE have some empty values. If I run the query below, it returns only students that have data in these two columns H.TEACHER_CODE and H.COUNTRY_CODE. However, I want to select all students whether they have data in these two columns or not. If they have data in H.TEACHER_CODE and H.COUNTRY_CODE column, then return Teacher and Country also, if they don't have, just return students without Teacher or Country. So, how do I select all students with or without Teacher or Country?