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@dorna.es
Technical Engineer http://www.motograndprix.com
Dorna Sports S.L. +34 93 4702864