pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Ricardo Javier Aranibar León <ricardo_jal@hotmail.com>
To: pgsql-sql@postgresql.org
Date: Thu, 19 Sep 2002 20:30:29 +0000
Message-ID: <F39LVbNDN4CxpAOAkK50000781b@hotmail.com> (raw)

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




view thread (2+ messages)  latest in thread

Message-ID: <F39LVbNDN4CxpAOAkK50000781b@hotmail.com>
Permalink:  ../F39LVbNDN4CxpAOAkK50000781b@hotmail.com/
Also on:    postgresql.org/message-id/F39LVbNDN4CxpAOAkK50000781b@hotmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: ricardo_jal@hotmail.com
  Subject: Re: 
  In-Reply-To: <F39LVbNDN4CxpAOAkK50000781b@hotmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox