Re: Query muy complicada

On Thu, Jun 09, 2005 at 04:52:55PM -0400, Mario Soto Cordones - Venezuela wrote:

> select va_vneto
> from contabilidad.sahidep a,
> crosstab('select codigo, empresa, filial, nombre,
> samafilial.nb_filial, samaubi.nb_ubicacion,co_contable, co_tecnico,
> descampo, valor_campo from _vasaf_systbl_1 ,
> samafilial , samaubi, activos
> where _vasaf_systbl_1.id_estado = ''SA'' and empresa =1 and
> _vasaf_systbl_1.empresa = samafilial.co_empresa and
> _vasaf_systbl_1.filial = samafilial.co_filial and
> _vasaf_systbl_1.empresa = activos.co_empresa and
> _vasaf_systbl_1.codigo = activos.nu_activo_fijo and
> _vasaf_systbl_1.empresa = samaubi.co_empresa and
> _vasaf_systbl_1.filial = samaubi.co_filial and
> _vasaf_systbl_1.ubicacion = samaubi.co_ubicacion AND
> modelo =4 And filial = 2
> group by codigo, empresa, filial, nombre,
> samafilial.nb_filial, samaubi.nb_ubicacion,co_contable, co_tecnico,
> descampo , valor_campo
> order by 1',
> 'select ''ANCHO MTS.'' union all select ''AREA M2''
> union all select ''LARGO MTS.'' union all select ''TIPO DE PROPIEDAD''
> union all select ''TOMO'' ') as
> ( codigo varchar, empresa integer, filial integer,
> nombre varchar, nb_filial varchar, nb_ubicacion varchar, co_contable
> varchar, co_tecnico
> varchar, "ANCHO MTS." varchar ,"AREA M2" varchar
> ,"LARGO MTS." varchar ,"TIPO DE PROPIEDAD" varchar ,"TOMO" varchar )
> c
>
>
> where
> a.co_empresa = empresa and
> a.co_filial = filial and
> a.co_codigo = codigo

Que es esa "c" que hay al final de la definicion del crosstab, antes del
where?

--
Alvaro Herrera (<alvherre[a]surnet.cl>)
"I suspect most samba developers are already technically insane...
Of course, since many of them are Australians, you can't tell." (L. Torvalds)