2 Replies Latest reply: Jul 12, 2012 4:54 AM by databyran RSS

    Count occurrences

      Hello.

       

      I have two tables called DONOR (key DONOR_ID) and DONATION (DONATION_ID). They are connected via DONOR_ID.

      Now I want to count how many Donors(uniqe DONOR_ID) that have exactly 2 donations(DONATION_ID).

       

      How do i achieve this?

       

      Regards

      Databyran