case

[#1]

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

[#2]

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.