problem with query

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