Is it possible to use a view into another view

[Cesar Bazan]

Hi everybody,

I have already built some views, involving some primary tables/entities in my model and they work fine.

Now, I want to use my basic views, in order to build more complex views.

The code that I've tried is:

-------------------------------------------------------------
CREATE OR REPLACE VIEW `sicoiprueba`.`AdministracionLocalidadInmueblePropietario` AS
SELECT a.*, li.*, p.*
FROM contratoAdministracion2 a
LEFT OUTER JOIN cgPropietario2 p
ON p.IDPROPIETARIO = a.cgPropietario2_IDPROPIETARIO
LEFT OUTER JOIN localidadInmueble li
ON li.IDLOCALIDAD = a.cgLocalidad2_IDLOCALIDAD
-------------------------------------------------------------

where contratoAdministracion2 and cgPropietario2 are simple entities and localidadInmueble is a basic view (based on other tables, not important at this point.

When I execute this code I get a 1146 error number ("localidadInmueble" doesn't exist).

Am I missing something? Is it possible to be done?

Thanks in advance