Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B5843476453 for ; Thu, 19 Sep 2002 15:12:30 -0400 (EDT) Received: from hotmail.com (f23.law9.hotmail.com [64.4.9.23]) by postgresql.org (Postfix) with ESMTP id EE42D47638A for ; Thu, 19 Sep 2002 15:12:29 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 19 Sep 2002 12:11:40 -0700 Received: from 64.7.127.220 by lw9fd.law9.hotmail.msn.com with HTTP; Thu, 19 Sep 2002 19:11:40 GMT X-Originating-IP: [64.7.127.220] From: =?iso-8859-1?B?UmljYXJkbyBKYXZpZXIgQXJhbmliYXIgTGXzbg==?= To: pgsql-sql@postgresql.org Subject: problem with query Date: Thu, 19 Sep 2002 19:11:40 +0000 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed Message-ID: X-OriginalArrivalTime: 19 Sep 2002 19:11:40.0619 (UTC) FILETIME=[6262F1B0:01C26010] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/225 X-Sequence-Number: 9502 Hi list, I need your help, I need a table or view with this information that show down,I have two tables "ticket" and "orden_respuesta" and I like this table. Note, that some tti for example (TTI02000008) of ticket it isn't in the table orden_respuesta, if somone can help me i will thank full tti | numorden | tt | usuario | estado | tipo -------------+----------------------------+--------+---------+----------+---------- TTI02000006 | ORD02000046, ORD02000045 ..| 100029 | joroza | CERRADO | ESPECIFI TTI02000007 | ORD02000064, ORD02000061 | 100051 | joroza | REVISION | ESPECIFI TTI02000008 | (****** nothing ***** ) | 100049 | joroza | REVISION | IP TTI02000009 | ORD02000040 | 56729 | joroza | CERRADO | FACTURA 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 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