Try this : Use
SELECT * from propertyfield as pf LEFT JOIN property as p ON (pf.pfid = p.propID)
From your question, It says that
p.propID has null values. So let the
propertyfield be your left tabe, which gives all data from it. and
property be your right table, which gives the corresponding values or null if no values.
solved mysql Left,right join not return null values