pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feed(no subject)
2+ messages / 2 participants
[nested] [flat]
* (no subject)
@ 2002-09-19 20:30 Ricardo Javier Aranibar León <ricardo_jal@hotmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Ricardo Javier Aranibar León @ 2002-09-19 20:30 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re:
@ 2002-09-20 10:35 Richard Huxton <dev@archonet.com>
parent: Ricardo Javier Aranibar León <ricardo_jal@hotmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Richard Huxton @ 2002-09-20 10:35 UTC (permalink / raw)
To: Ricardo Javier Aranibar León <ricardo_jal@hotmail.com>; pgsql-sql
On Thursday 19 Sep 2002 9:30 pm, Ricardo Javier Aranibar León wrote:
> Hi list,
Hi Ricardo
> I need your colaboration,I like a table or view with this information
> from 2 tables "ticket" and "orden_respuesta".
>
> numtti | numorden | tt | usuario | estado |
> -----------+---------------------------+--------+---------+---------+
> TTI02000006| ORD02000046, ORD02000045..| 100029 | joroza | CERRADO |
>
> -------------+--------+---------+----------+
> TTI02000006 | 100029 | joroza | CERRADO |
>
> -------------+-------------
> ORD02000046 | TTI02000006
> ORD02000045 | TTI02000006
Do a search on aggregate functions and "concat" in the mailing list archives,
also see the Postgresql Cookbook on techdocs.postgresql.org, I think there
might be something there for you.
That's assuming you don't care about order of course.
- Richard Huxton
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-09-20 10:35 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-09-19 20:30 Ricardo Javier Aranibar León <ricardo_jal@hotmail.com>
2002-09-20 10:35 ` Re: Richard Huxton <dev@archonet.com>
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