The problem is that i have two IDs in the table SEMENSALES pointing to the same id on table CV, let me explain you with this example:

in table SEMENSALES:
IDMARE IDENTIFICATION SEMENVALUE
1 3 15
1 4 30
2 3 10

In table CV
IDENTIFICATION NAME GENDER
1 LAMA MARE
2 CHICA MARE
3 PEPE HORSE
4 LOCO HORSE


the querie output should be:
IDMARE IDENTIFICATION NAMEMARE NAMEHORSE SEMENVALUE
1 3 LAMA PEPE 15
1 4 LAMA LOCO 30
2 3 CHICA PEPE 10


thanks .