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

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
==================

On Mar 8, 11:24*am, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> 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.
> jstuck...@attglobal.net
> ==================- Hide quoted text -
>
> - Show quoted text -

Here is the url to phpmyadmin.
http://74.220.207.77:2082/3rdparty/p...min/index.php?
I would appreciate any help you can offer. I am stumped here.
Please email me personally for the username and password if you can
help.
Thanks in advance!!

aneunz wrote:
> On Mar 8, 11:24 am, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> 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.
>> jstuck...@attglobal.net
>> ==================- Hide quoted text -
>>
>> - Show quoted text -
>
> Here is the url to phpmyadmin.
> http://74.220.207.77:2082/3rdparty/p...min/index.php?
> I would appreciate any help you can offer. I am stumped here.
> Please email me personally for the username and password if you can
> help.
> Thanks in advance!!
>

Please post the info here in the newsgroup.

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