PHP, MySQL, Displaying tow tables having one similar colume Options

[akeredolujosh]

Please I have two different tables namely Land owners and property respectively with the following columes:
table 1: Land owners > Columes are: id, fileno, type of ownership, firstname, last, sex.
table 2: Property > Columes are: id, fileno, doe, plotno, location.
Please how can i use php to display the data on both tables of which the data on fileno colume on both table are the same

This post has been edited by akeredolujosh: Mar 3 2014, 08:43 AM