MariaDB [libreria]> select libro.titulo,autor.nombre from libro,autor,liautedi where libro.titulo='Estructura de datos' and libro.id_libro=liautedi.id_libro1 and liautedi.codaut1=autor.codaut;
Empty set (0.001 sec)

MariaDB [libreria]> select * from libro;
+----------+---------------------+-------+--------+-----------+
| id_libro | Titulo              | Numpg | Precio | codigmat1 |
+----------+---------------------+-------+--------+-----------+
| L01      | C lculo II          |   120 |  55000 | M01       |
| L02      | Bd II               |   150 |  65000 | M09       |
| L03      | Estructura de Datos |   180 |  85000 | M03       |
| L04      | Ingl‚s              |   280 | 105000 | M04       |
| L05      | Admon en una p gina |    70 |   7500 | M05       |
| L06      | Contabiloidad I     |   170 |  27500 | M06       |
| L07      | Redes               |   370 |  32500 | M07       |
+----------+---------------------+-------+--------+-----------+
7 rows in set (0.001 sec)

MariaDB [libreria]> select * from autor;
+--------+---------------------+
| codaut | Nombre              |
+--------+---------------------+
| A01    | Luis Joyanes        |
| A02    | Jorge Vaquez Posada |
| A03    | Jhon Soars          |
| A04    | Riaz Khadem         |
| A05    | Robert Lorber       |
| A06    | Mario Dream         |
+--------+---------------------+
6 rows in set (0.000 sec)

MariaDB [libreria]> select * from liautedi;
+-----------+---------+----------+
| id_libro1 | codaut1 | codedit1 |
+-----------+---------+----------+
| L02       | A01     | E01      |
| L02       | A05     | E03      |
| L06       | A02     | E02      |
| L07       | A05     | E03      |
| L04       | A04     | E01      |
| L04       | A04     | E02      |
| L04       | A04     | E03      |
+-----------+---------+----------+
7 rows in set (0.000 sec)

MariaDB [libreria]> select libro.titulo,autor.nombre from libro,autor,liautedi where autor.nombre='luis joyanes' and libro.id_libro=liautedi.id_libro1 and liautedi.codaut1=autor.codaut;
+--------+--------------+
| titulo | nombre       |
+--------+--------------+
| Bd II  | Luis Joyanes |
+--------+--------------+
1 row in set (0.001 sec)

MariaDB [libreria]> select libro.titulo,autor.nombre from libro,autor,liautedi where libro.titulo='BD II' and libro.id_libro=liautedi.id_libro1 and liautedi.codaut1=autor.codaut;
+--------+---------------+
| titulo | nombre        |
+--------+---------------+
| Bd II  | Luis Joyanes  |
| Bd II  | Robert Lorber |
+--------+---------------+
2 rows in set (0.001 sec)

MariaDB [libreria]> select libro.titulo 'LIBRO',autor.nombre 'AUTOR' from libro,autor,liautedi where libro.titulo='BD II' and libro.id_libro=liautedi.id_libro1 and liautedi.codaut1=autor.codaut;
+-------+---------------+
| LIBRO | AUTOR         |
+-------+---------------+
| Bd II | Luis Joyanes  |
| Bd II | Robert Lorber |
+-------+---------------+
2 rows in set (0.001 sec)

MariaDB [libreria]> describe editorial;
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| codedit | varchar(10) | NO   | PRI | NULL    |       |
| Nombre  | varchar(20) | NO   |     | NULL    |       |
+---------+-------------+------+-----+---------+-------+
2 rows in set (0.035 sec)

MariaDB [libreria]> select libro.titulo 'LIBRO',autor.nombre 'AUTOR',editorial.nombre from libro,autor,liautedi,editorial where libro.id_libro=liautedi.id_libro1 and liautedi.codaut1=autor.codaut and editorial.codedit=liuatedi.coedit1;
ERROR 1054 (42S22): Unknown column 'liuatedi.coedit1' in 'where clause'
MariaDB [libreria]> select libro.titulo 'LIBRO',autor.nombre 'AUTOR',editorial.nombre from libro,autor,liautedi,editorial where libro.id_libro=liautedi.id_libro1 and liautedi.codaut1=autor.codaut and editorial.codedit=liuatedi.codedit1;
ERROR 1054 (42S22): Unknown column 'liuatedi.codedit1' in 'where clause'
MariaDB [libreria]> select libro.titulo 'LIBRO',autor.nombre 'AUTOR',editorial.nombre from libro,autor,liautedi,editorial where libro.id_libro=liautedi.id_libro1 and liautedi.codaut1=autor.codaut and editorial.codedit=liuatedi.codedit1;
ERROR 1054 (42S22): Unknown column 'liuatedi.codedit1' in 'where clause'
MariaDB [libreria]> describe liautedi;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| id_libro1 | varchar(10) | NO   | MUL | NULL    |       |
| codaut1   | varchar(10) | NO   | MUL | NULL    |       |
| codedit1  | varchar(10) | NO   | MUL | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
3 rows in set (0.004 sec)

MariaDB [libreria]> select libro.titulo 'LIBRO',autor.nombre 'AUTOR',editorial.nombre from libro,autor,liautedi,editorial where libro.id_libro=liautedi.id_libro1 and liautedi.codaut1=autor.codaut and editorial.codedit=liautedi.codedit1;
+-----------------+---------------------+--------------+
| LIBRO           | AUTOR               | nombre       |
+-----------------+---------------------+--------------+
| Bd II           | Luis Joyanes        | Oveja Negra  |
| Ingl‚s          | Riaz Khadem         | Oveja Negra  |
| Contabiloidad I | Jorge Vaquez Posada | Norma        |
| Ingl‚s          | Riaz Khadem         | Norma        |
| Bd II           | Robert Lorber       | Mc Graw Hill |
| Redes           | Robert Lorber       | Mc Graw Hill |
| Ingl‚s          | Riaz Khadem         | Mc Graw Hill |
+-----------------+---------------------+--------------+
7 rows in set (0.001 sec)

MariaDB [libreria]> color 17
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'color 17' at line 1
MariaDB [libreria]> exit