problems with this wiew

Hi.

I've got a problem with this "wiew":

select gallery_id, multimedia_id
from (view_multimedia_file A
inner join ( select gallery_id,
multimedia_id,
element_type_id,
result_type_id,
subevent_id,
subevent_type_id,
event_id,
championship_id,
championship_type_id,
season_id,
c_language_id as language_id

from ( view_gallery B
inner join ( select gallery_id as c_gallery_id,
result_type_id,
subevent_id,
subevent_type_id,
event_id,
championship_id,
championship_type_id,
season_id,
language_id as c_language_id
from view_gallery_result_type
) C
on (B.gallery_id = C.c_gallery_id)
) D

) E

on ( (A.mm_id = E.multimedia_id)
)

);

select *
from (view_multimedia_file A
inner join ( select gallery_id,
multimedia_id,
element_type_id,
result_type_id,
subevent_id,
subevent_type_id,
event_id,
championship_id,
championship_type_id,
season_id,
c_language_id as language_id

from ( view_gallery B
inner join ( select gallery_id as c_gallery_id,
result_type_id,
subevent_id,
subevent_type_id,
event_id,
championship_id,
championship_type_id,
season_id,
language_id as c_language_id
from view_gallery_result_type
) C
on (B.gallery_id = C.c_gallery_id)
) D

) E

on ( (A.mm_id = E.multimedia_id)
)

);

The postgresql show error.
Anybody can help me, please??

Thank you very much.

Have a nice day ;-)
TooManySecrets

--
Manuel Trujillo manueltrujillo(at)dorna(dot)es
Technical Engineer http://www.motograndprix.com
Dorna Sports S.L. +34 93 4702864