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
Cc: ricardo_jal@linuxmail.org
Cc: jaranibar@heilsbergbol.com
Subject: problem with query
Date: Thu, 19 Sep 2002 19:48:21 +0000
Message-ID: <F1086XQQez1enAqpfkN000002fb@hotmail.com> (raw)

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




view thread (5+ messages)  latest in thread

Message-ID: <F1086XQQez1enAqpfkN000002fb@hotmail.com>
Permalink:  ../F1086XQQez1enAqpfkN000002fb@hotmail.com/
Also on:    postgresql.org/message-id/F1086XQQez1enAqpfkN000002fb@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, ricardo_jal@linuxmail.org, jaranibar@heilsbergbol.com
  Subject: Re: problem with query
  In-Reply-To: <F1086XQQez1enAqpfkN000002fb@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