Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E4BA4476292 for ; Thu, 19 Sep 2002 15:48:21 -0400 (EDT) Received: from hotmail.com (f108.law9.hotmail.com [64.4.9.108]) by postgresql.org (Postfix) with ESMTP id 322C7475EA8 for ; Thu, 19 Sep 2002 15:48:21 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 19 Sep 2002 12:48:22 -0700 Received: from 64.7.127.220 by lw9fd.law9.hotmail.msn.com with HTTP; Thu, 19 Sep 2002 19:48:21 GMT X-Originating-IP: [64.7.127.220] From: =?iso-8859-1?B?UmljYXJkbyBKYXZpZXIgQXJhbmliYXIgTGXzbg==?= To: pgsql-sql@postgresql.org Cc: ricardo_jal@linuxmail.org, jaranibar@heilsbergbol.com Subject: problem with query Date: Thu, 19 Sep 2002 19:48:21 +0000 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed Message-ID: X-OriginalArrivalTime: 19 Sep 2002 19:48:22.0123 (UTC) FILETIME=[8295CBB0:01C26015] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/226 X-Sequence-Number: 9503 Hi list, First sorry if this message arrive in your box mail twice, 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 to "numorden" in the table orden_respuesta, if someone can help me i will thankfull numtti | numorden | tt | usuario | estado | tipo -------------+---------------------------+--------+---------+----------+------------- TTI02000006 | ORD02000046, ORD02000045..| 100029 | joroza | CERRADO | ESPECIFI TTI02000007 | ORD02000064, ORD02000061..| 100051 | joroza | REVISION | ESPECIFI TTI02000008 | (***void***) | 100049 | joroza | REVISION | IP TTI02000009 | ORD02000040 | 56729 | joroza | CERRADO | FACTURA ////////////// table ticket// ////////////// hb=# select tti, tt, usuario, estado, tipo from ticket; tti | tt | usuario | estado | tipo -------------+--------+---------+----------+------------- TTI02000006 | 100029 | joroza | CERRADO | ESPECIFICO TTI02000007 | 100051 | joroza | REVISION | ESPECIFICO TTI02000008 | 100049 | joroza | REVISION | IP TTI02000009 | 56729 | joroza | CERRADO | FACTURACION /////////////////////// 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 _________________________________________________________________ Charle con sus amigos online usando MSN Messenger: http://messenger.msn.com