Results 1 to 2 of 2

Thread: report

  1. #1
    Join Date
    Apr 2003

    Unanswered: 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.


  2. #2
    Join Date
    Aug 2003
    you 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts