problem with query

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