SELECT t.A*100+t1.A*10+t2.A AS X, t.A+t1.A*10+t2.A*100 AS Y, t.A*99-t2.A*99 AS Z
FROM t, t AS t1, t AS t2
WHERE (t.A<>t1.A And t.A<>t2.A) AND (t1.A<>t2.A) AND ((t.A*99-t2.A*99)>99 AND (t.A*99-t2.A*99) Like '*' & t.A & '*' AND (t.A*99-t2.A*99) Like '*' & t1.A & '*' AND (t.A*99-t2.A*99) Like '*' & t2.A & '*');
|