report

I have a table a. It has the data of all the people in the county who represented in some event.suppose i have 100 cities in the county and i have values for only 64 counties.I dont have the values for the rest of 36 cities.Any how i want to display the othercities with zero values. means
city number
a 34
b 56
C 0
d 23
e 0,

But the cities c and e are not there in the table.
How can i get this report.

Thanksyou have to join the table with the data of the events (table a?) and the table with the cities. When you use right outer join you get all the cities.