Thread: ...

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

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