Consultar 2 referencias a registros de la misma tabla

[huesos52]

primero que todo, haría las anidaciones con sentencias join y no con anidaciones en el where.

Código sql:

SELECT b.latx AS xini, b.logy AS yini, c.latx AS xfin, c.logy AS yfin
FROM ARISTAS a 
INNER JOIN
(SELECT * FROM NODOS WHERE QTREE LIKE '102213320333120%') b
ON a.INI = b.ID 
INNER JOIN 
(SELECT * FROM NODOS WHERE QTREE LIKE '102213320333120%') c 
ON a.FIN = c.ID