Consulta MYSQL compleja

[ZedGe1505]

Suponiendo que tienes

Código MySQL:

CREATE TABLE fcart001
(
ACODAR int,
ARESNUM4 int
);
 
CREATE TABLE fcalt001
(
SCOD int,
SART int
);
 
INSERT INTO fcart001 VALUES (1, 2);
INSERT INTO fcart001 VALUES (2, 2);
INSERT INTO fcart001 VALUES (3, 2);
INSERT INTO fcart001 VALUES (4, 1);
INSERT INTO fcart001 VALUES (5, 1);
INSERT INTO fcart001 VALUES (6, 1);
INSERT INTO fcart001 VALUES (7, 3);
INSERT INTO fcart001 VALUES (8, 3);
INSERT INTO fcart001 VALUES (9, 3);
INSERT INTO fcart001 VALUES (10, 4);
 
 
INSERT INTO fcalt001 VALUES (1, 1);
INSERT INTO fcalt001 VALUES (3, 2);
INSERT INTO fcalt001 VALUES (3, 3);
INSERT INTO fcalt001 VALUES (1, 4);
INSERT INTO fcalt001 VALUES (3, 5);
INSERT INTO fcalt001 VALUES (2, 6);
INSERT INTO fcalt001 VALUES (1, 7);
INSERT INTO fcalt001 VALUES (3, 8);
INSERT INTO fcalt001 VALUES (2, 9);
INSERT INTO fcalt001 VALUES (1, 10);
 

La query (si no me equivoco ya que me he mareado xD)

Código SQL:

SELECT * FROM fcart001, fcalt001
WHERE ARESNUM4 = 3 AND fcart001.ACODAR = fcalt001.SART
AND fcalt001.SCOD NOT IN (
SELECT scod FROM fcart001, fcalt001  
WHERE ARESNUM4 = 2 AND fcart001.ACODAR = fcalt001.SART
)
 

Ahora lo que no entiendo es que has dicho que "(rl producto 2 seria la altrenativa del 3 y del 4 y viceversa)." El producto 2 no es alternativa del 3 y del 1???