On the terminal prompt, type: python3 py-fetchall-mysql.py

Modify the script py-fetchall-mysql.py and locate the query variable assignment line: query = ("select * from owner") Comment out the statement by a "#" sign in the line like the other comments. Uncomment the line(take the "#" out): # query = ("select * from property p, owner o where p.ownerNo = o.ownerNo")

query = python3 py-fetchall-mysql.py >

o.ownerNo

Owner.txt

ownerNo

ownerNo.txt

Property

property.txt

What script may be written to achieve the required results?