SQL - ayuda con subconsulta

select fecha from datos where tipo= tipo2 and RF = referencia

no entiendo como desde la consulta anidada puedo hacer referencia al campo RF de la consulta principal

mysql> SELECT * FROM tabla;

+------------+------------+------+-------+

| Referencia | Fecha      | tipo | TIPO2 |

+------------+------------+------+-------+

|          1 | 2017-01-01 | VE   | VE    |

|          1 | 2016-12-05 | CD   | VE    |

|          1 | 2007-01-30 | CO   | VE    |

|          2 | 2016-10-05 | VE   | VE    |

|          2 | 2017-10-07 | PL   | VE    |

|          3 | 2016-08-02 | VE   | VE    |

|          3 | 2016-08-30 | NC   | VE    |

|          3 | 2016-08-25 | PL   | VE    |

+------------+------------+------+-------+

8 rows in set (0.00 sec)

mysql> SELECT

    ->   T1.referencia,

    ->   T1.fecha,

    ->   T1.tipo,

    ->   T1.tipo2,

    ->   ( SELECT T2.fecha

    ->     FROM tabla T2

    ->     WHERE T2.tipo = T1.tipo2

    ->           AND T2.referencia = T1.referencia) otra_fecha

    -> FROM tabla T1;

+------------+------------+------+-------+------------+

| referencia | fecha      | tipo | tipo2 | otra_fecha |

+------------+------------+------+-------+------------+

|          1 | 2017-01-01 | VE   | VE    | 2017-01-01 |

|          1 | 2016-12-05 | CD   | VE    | 2017-01-01 |

|          1 | 2007-01-30 | CO   | VE    | 2017-01-01 |

|          2 | 2016-10-05 | VE   | VE    | 2016-10-05 |

|          2 | 2017-10-07 | PL   | VE    | 2016-10-05 |

|          3 | 2016-08-02 | VE   | VE    | 2016-08-02 |

|          3 | 2016-08-30 | NC   | VE    | 2016-08-02 |

|          3 | 2016-08-25 | PL   | VE    | 2016-08-02 |

+------------+------------+------+-------+------------+

8 rows in set (0.00 sec)

SELECT

  ALIAS_1.movnumdocref,

  ( SELECT ALIAS_2.movfv

    FROM softland.cwmovim ALIAS_2

    WHERE ALIAS_2.ttdcod = ALIAS_1.movtipdocref) AS FVEN

FROM

  softland.cwmovim ALIAS_1

WHERE

      ALIAS_1.codaux='79911860-2'

      AND ALIAS_1.cpbnum<>'00000000'

      AND ALIAS_1.pctcod='1-01-04-03'

ORDER BY ALIAS_1.movnumdocref, ALIAS_1.codaux, ALIAS_1.movfe;