On Friday 20 September 2002 16:46, Ricardo Javier Aranibar León wrote: > Hi List,
Hello > > The Table "result"(I like this information) > numtti | numorden | tt | usuario | estado | > ----------+---------------------------+--------+---------+---------+ > TTI02000006| ORD02000044, ORD02000045..| 100029 | joroza | CERRADO | > TTI02000007| ORD02000061, ORD02000064 | 100051 | pdorado | REVISION| > TTI02000008| ORD02000042, ORD02000043 | 56729 | joroza | CERRADO | > Normally I would say use a "create view as select ... .". but I am not sure if this will display your needs. Do you really need the data like "ORD02000044, ORD02000045..." ? Then you should use an array or set datatype. They are normally not nice to handel. regards -andreas -- Andreas Schmitz - Phone +49 201 8501 318 Cityweb-Technik-Service-Gesellschaft mbH Friedrichstr. 12 - Fax +49 201 8501 104 45128 Essen - email [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
