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