05/02/2007, 14:24
|
| | | Fecha de Ingreso: noviembre-2006
Mensajes: 17
Antigüedad: 18 años Puntos: 0 | |
Re: SQL-convertir FILAS en COLUMNAS Una solución rápida que se me ocurre sería
select
(select cliente from tabla where cliente = 'cliente') as cliente,
(select dato1 from tabla where cliente = 'cliente') as col1,
(select dato2 from tabla where cliente = 'cliente') as col2,
(select dato3 from tabla where cliente = 'cliente') as col3,
(select dato4 from tabla where cliente = 'cliente') as col4 |