MySQL SQL Syntax question multiple table query

I have two tables 'Residential' and 'property_coordinates' that feature both feature a sMLSNumber field and the Residential table has a sSubdivision field.  I am trying to select all data where the sSubdivision equals Pines in table Residential and the sMLSNumber matches in both tables.  What am I doing wrong?  Can someone edit my syntax to work properly?

SELECT * FROM Residential, property_coordinates
	WHERE sSubdivision='Pines'
	AND sMLSNumber=sMLSNumber"

Select allOpen in new window