mysql join query

gistfile1.txt

SELECT
    p.name,
    h.number,
    h.streetname
FROM
    people p
LEFT JOIN houses h 
    ON p.lives_in_house_id = h.id
WHERE h.number = '1' AND
      h.streename = 'Elm Street';