Dear Anilkumar
I have recently downloaded postgresql-7.0.2 and studying that wonderful
database. May be the same query language worksin MySQL.
select location.country, count(*)
where location.country=church_details.country
group on location.country;
This query will group and display if there is atleast one church in the
country table.
select country from location
where not exists (location.country=church_details.country)
will list countries from table location where there are no churches in
the table church_details.
I think it would help if a domain is defined for country and used in
both tables, or data defination of attribute country is identical in
both tables.
Vijay
Anilkumar wrote:
>
> Dear MySQL Users,
> I am facing problem in MySQL querry , I need
> results like
>
> Country Total
> India (2)
> Lanka (1)
> China (1)
> Russia (0)
> Afganistan (0)
>
----------------------------------------------
LIH is all for free speech. But it was created
for a purpose. Violations of the rules of
this list will result in stern action.
