Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.