>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 such circumstances, it is not a problem. You only have to add another INNER JOIN with the AS clause. Here is an example:
SELECT Parent.Name,Parent2.Name FROM Child;
INNER JOIN Parent ON Child.NoParent=Parent.PrimaryKey;
INNER JOIN Parent AS Parent2 ON Child.NoParent2=Parent2.PrimaryKey;
WHERE ...