From: Ricardo Javier Aranibar León <ricardo_jal@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: problem with query
Date: Thu, 19 Sep 2002 19:11:40 +0000
Message-ID: <F23NGH1tKsehOznI2vd00007504@hotmail.com> (raw)
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
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: problem with query
In-Reply-To: <F23NGH1tKsehOznI2vd00007504@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