05/02/2007, 14:24
|
 | | | Fecha de Ingreso: noviembre-2006
Mensajes: 17
Antigüedad: 17 años, 6 meses 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 |