problems with this wiew - Mailing list pgsql-sql

From Manuel Trujillo
Subject problems with this wiew
Date
Msg-id 20011204111047.GA10294@dorna.es
Whole thread Raw
Responses Re: problems with this wiew
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: An easy question about creating a primary key
Next
From: Roland Roberts
Date:
Subject: Re: Need help with a college SQL exam question...