SQL Select Issue

Question

If the client.race field is blank for a row then it is not selected in the statement below. However, I want these rows to be select. Is there a way to do this?

SELECT last_name, client.race, ethnicity.descrip From client  
JOIN ethnicity on client.race = ethnicity.race  
  

Answer 1

SELECT last_name, client.race, ethnicity.descrip   
From client  
 LEFT JOIN ethnicity on client.race = ethnicity.race