[Solved] mysql Left,right join not return null values

Question

Try this : Use LEFT JOIN

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.

Accepted Answer

Try this : Use LEFT JOIN

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.