1 Reply Latest reply: Sep 13, 2012 4:30 AM by Claudia Zwick RSS

    case

      HI , i have this problem, i have a tale call GRUPO that contain:

       

      Grupo

      ====

      Aplicaciones

      Infraestructura

      Soporte

       

      and also i have a table call ASIGNATARIO that contain

       

      ASIGNATARIo

      ==========

      Flores Pepe

      Ramos Marco

      Macoto Luis

      Romero Percy

       

      and my last table call TICKET that containt de different numbers of tkcet oiek this:

       

      TICKET

      =====

      1234

      2345

      3456

      4567

       

      I need to assign each ticket that contains an assign X to the group for that assignee. Thanks

        • Re: case

          Hi,

           

          are there any relations between these tables?

           

          Otherwise the result of joining would be:

           

          Aplicaciones, Flores Pepe, 1234

          Aplicaciones, Flores Pepe, 2345

          Aplicaciones, Flores Pepe, 3456

          Aplicaciones, Flores Pepe, 4567

          Aplicaciones, Ramos Marco, 1234

          Aplicaciones, Ramos Marco, 2345

          Aplicaciones, Ramos Marco, 3456

          Aplicaciones, Ramos Marco, 4567

           

          and so on. Every value of the first table with every value of the other ones.