[Solved] mysql Left,right join not return null values
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 … Read more