Received: from montseny-f.ibernet.com (bcnsf.jazztel.es [212.106.195.71] (may be forged)) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB4B7Rm79019 for ; Tue, 4 Dec 2001 06:07:27 -0500 (EST) (envelope-from manueltrujillo@dorna.es) Received: from klingon.dorna.es ([212.163.226.3]) by montseny-f.ibernet.com (Post.Office MTA v3.5.3 release 223 ID# 0-70794U9000L900S0V35) with ESMTP id com for ; Tue, 4 Dec 2001 12:03:25 +0100 Received: from toomany by klingon.dorna.es with local (Exim 3.33 #1 (Debian)) id 16BDTM-0002jK-00 for ; Tue, 04 Dec 2001 12:10:48 +0100 Date: Tue, 4 Dec 2001 12:10:47 +0100 From: Manuel Trujillo To: pgsql-sql@postgresql.org Subject: problems with this wiew Message-ID: <20011204111047.GA10294@dorna.es> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.24i X-Archive-Number: 200112/34 X-Sequence-Number: 5857 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