SELECT neunzy_districts.*,neunzy_data_with_phone_number.*
FROM neunzy_districts INNER JOIN neunzy_data_with_phone_number ON
(neunzy_districts.residential_address1=concat(neun zy_data_with_phone_number.streetnumber,'
',neunzy_data_with_phone_number.streetname) Or
neunzy_districts.residential_address1=concat(neunz y_data_with_phone_number.streetnumber,'
',neunzy_data_with_phone_number.streetname)) and
neunzy_districts.LAST_NAME=neunzy_data_with_phone_ number.LastName AND
neunzy_districts.FIRST_NAME=neunzy_data_with_phone _number.FirstName;

This query is not returning all of the expected results from these two
tables. The results that are being returned seem to be only those
where residential_address has a directional prefix, e.g. 123 N ELM
ST., or 697 E MARKET ST. Can anyone see a problem with the query
syntax?

Thanks in advance,
Aaron Neunz