|
|
Posted by strawberry on 07/06/06 08:56
untested...!
select distinct zip,region,count(idperson)
from table1
left join table2 on table2.zip = table 1.zip
group by zip
Bob Bedford wrote:
> Hi Paul,
>
> > Might I suggest that this might be better asked in comp.databases.mysql
>
> Unfortunately, I don't have access to mysql newsgroup, that's why I ask
> here, as many php programmers are also mysql addicts...
>
> Bob
Navigation:
[Reply to this message]
|