2 Replies Latest reply: Sep 18, 2015 9:12 AM by João Paulo Pato RSS

    Count rows with specific attributes

    João Paulo Pato

      Tables


      RESTAURANTS

           NAME_RES

      PRODUCTS

           NAME_PROD

           PRODUCER

      RESTAURANTS_PRODUCTS

           NAME_RES

           NAME_PROD    

       

      I want to count how many Products from a specific Producer do i have in a given Restaurant.

       

      Anybody can tell me how to solve this ?


      Thanks !