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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
