aneunz wrote:
> 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
>

Without the data you're using, no.

And your table definitions would be an asset, also.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================