if-clause in select query
Maybe something like this:

SELECT 
  p.last_name, 
  p.first_name, 
  a.street, 
  a.house_nr, 
  a.post_code, 
  a.city 
FROM persons AS p
LEFT JOIN addresses AS a 
WHERE p.id=42