Ayuda con Vista SQL

[huesos52]

Lo mas cercano sería utilizar group_concat.

Código MySQL:

mysql> SELECT *FROM tablaA;
+------+------+-------+
| id   | data | desc1 |
+------+------+-------+
|    1 | X    | Y     |
+------+------+-------+
1 row in set (0.03 sec)
 
mysql> SELECT *FROM tablaB;
+------+-------+
| id   | valor |
+------+-------+
|    1 | aaaa  |
|    1 | bbbb  |
+------+-------+
 
mysql> SELECT a.*,
>GROUP_CONCAT(b.valor  SEPARATOR ',') valores 
>FROM tablaA a 
>INNER JOIN tablaB b 
>ON a.id=b.id GROUP BY a.id;
+------+------+-------+-----------+
| id   | data | desc1 | valores   |
+------+------+-------+-----------+
|    1 | X    | Y     | aaaa,bbbb |
+------+------+-------+-----------+
1 row in set (0.03 sec)
 

Ya que no puedes convertir registros en columnas.

saludos