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