Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 057D7476803 for ; Thu, 19 Sep 2002 16:30:53 -0400 (EDT) Received: from hotmail.com (f39.law9.hotmail.com [64.4.9.39]) by postgresql.org (Postfix) with ESMTP id 0E22E4766DE for ; Thu, 19 Sep 2002 16:30:52 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 19 Sep 2002 13:30:29 -0700 Received: from 64.7.127.220 by lw9fd.law9.hotmail.msn.com with HTTP; Thu, 19 Sep 2002 20:30:29 GMT X-Originating-IP: [64.7.127.220] From: =?iso-8859-1?B?UmljYXJkbyBKYXZpZXIgQXJhbmliYXIgTGXzbg==?= To: pgsql-sql@postgresql.org Date: Thu, 19 Sep 2002 20:30:29 +0000 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed Message-ID: X-OriginalArrivalTime: 19 Sep 2002 20:30:29.0931 (UTC) FILETIME=[6546AFB0:01C2601B] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/227 X-Sequence-Number: 9504 Hi list, I need your colaboration,I like a table or view with this information from 2 tables "ticket" and "orden_respuesta". Note, that the tti (TTI02000008) doesn't have links or relations to "numorden" in the table orden_respuesta, if someone can help me i will thankfull numtti | numorden | tt | usuario | estado | -----------+---------------------------+--------+---------+---------+ TTI02000006| ORD02000046, ORD02000045..| 100029 | joroza | CERRADO | TTI02000007| ORD02000064, ORD02000061..| 100051 | joroza | REVISION| TTI02000008| (***void***) | 100049 | joroza | REVISION| TTI02000009| ORD02000040 | 56729 | joroza | CERRADO | ////////////// table ticket// ////////////// hb=# select tti, tt, usuario, estado, tipo from ticket; tti | tt | usuario | estado | -------------+--------+---------+----------+ TTI02000006 | 100029 | joroza | CERRADO | TTI02000007 | 100051 | joroza | REVISION | TTI02000008 | 100049 | joroza | REVISION | TTI02000009 | 56729 | joroza | CERRADO | /////////////////////// table orden_respuesta// /////////////////////// hb=# select * from orden_respuesta ; numorden | numtti -------------+------------- ORD02000046 | TTI02000006 ORD02000045 | TTI02000006 ORD02000044 | TTI02000006 ORD02000043 | TTI02000006 ORD02000042 | TTI02000006 ORD02000064 | TTI02000007 ORD02000061 | TTI02000007 ORD02000040 | TTI02000009 regards, Ricardo _________________________________________________________________ Únase al mayor servicio mundial de correo electrónico: http://www.hotmail.com/es