MariaDB [(none)]> show databases;
+---------------------+
| Database            |
+---------------------+
| bd_biblioteca       |
| escuela_superior_p2 |
| information_schema  |
| libreria            |
| matricula2          |
| mysql               |
| performance_schema  |
| phpmyadmin          |
| prueba              |
| test                |
+---------------------+
10 rows in set (0.006 sec)

MariaDB [(none)]> use libreria;
Database changed
MariaDB [libreria]> select * from libro;
+----------+---------------------+-------+----------+--------+---------+-----------+
| id_libro | Titulo              | Numpg | cantidad | Precio | vtotal  | codigmat1 |
+----------+---------------------+-------+----------+--------+---------+-----------+
| L01      | C lculo II          |   120 |        5 |  55000 |  275000 | M01       |
| L02      | Bd II               |   150 |       10 |  65000 |  650000 | M09       |
| L03      | Estructura de Datos |   180 |       15 |  85000 | 1275000 | M03       |
| L04      | Ingl‚s              |   280 |       20 | 105000 | 2100000 | M04       |
| L05      | Admon en una p gina |    70 |       25 |   7500 |  187500 | M05       |
| L06      | Contabilidad I      |   170 |       30 |  27500 |  825000 | M06       |
+----------+---------------------+-------+----------+--------+---------+-----------+
6 rows in set (0.008 sec)

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

MariaDB [libreria]> select libro.id_libro,libro.titulo,liautedi.id_libro1 from libro left join liautedi on libro.id_libro=liautedi.id_libro1 where liautedi.id_libro1 is null;
+----------+---------------------+-----------+
| id_libro | titulo              | id_libro1 |
+----------+---------------------+-----------+
| L01      | C lculo II          | NULL      |
| L03      | Estructura de Datos | NULL      |
| L05      | Admon en una p gina | NULL      |
+----------+---------------------+-----------+
3 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.004 sec)

MariaDB [libreria]> select libro.id_libro,libro.titulo,liautedi.id_libro1 from libro right join liautedi on libro.id_libro=liautedi.id_libro1;
+----------+----------------+-----------+
| id_libro | titulo         | id_libro1 |
+----------+----------------+-----------+
| L02      | Bd II          | L02       |
| L02      | Bd II          | L02       |
| L04      | Ingl‚s         | L04       |
| L04      | Ingl‚s         | L04       |
| L04      | Ingl‚s         | L04       |
| L06      | Contabilidad I | L06       |
+----------+----------------+-----------+
6 rows in set (0.001 sec)

MariaDB [libreria]> select distinct libro.id_libro,libro.titulo,liautedi.id_libro1 from libro right join liautedi on libro.id_libro=liautedi.id_libro1;
+----------+----------------+-----------+
| id_libro | titulo         | id_libro1 |
+----------+----------------+-----------+
| L02      | Bd II          | L02       |
| L04      | Ingl‚s         | L04       |
| L06      | Contabilidad I | L06       |
+----------+----------------+-----------+
3 rows in set (0.001 sec)

MariaDB [libreria]> select autor.codaut,autor.nombre,liautedi.codaut1 from autor left join liautedi on autor.codaut=liautedi.codaut1 where liautedi.codaut1 is null;
+--------+-------------+---------+
| codaut | nombre      | codaut1 |
+--------+-------------+---------+
| A03    | Jhon Soars  | NULL    |
| A06    | Mario Dream | NULL    |
+--------+-------------+---------+
2 rows in set (0.001 sec)

MariaDB [libreria]> select autor.codaut,autor.nombre,liautedi.codaut1 from autor right join liautedi on autor.codaut=liautedi.codaut1;
+--------+---------------------+---------+
| codaut | nombre              | codaut1 |
+--------+---------------------+---------+
| A01    | Luis Joyanes        | A01     |
| A02    | Jorge Vaquez Posada | A02     |
| A04    | Riaz Khadem         | A04     |
| A04    | Riaz Khadem         | A04     |
| A04    | Riaz Khadem         | A04     |
| A05    | Robert Lorber       | A05     |
+--------+---------------------+---------+
6 rows in set (0.001 sec)

MariaDB [libreria]> select editorial.codedit,editorial.nombre,liautedi.codedit1 from autor right join liautedi on editorial.codedit=liautedi.codedit1;
ERROR 1054 (42S22): Unknown column 'editorial.codedit' in 'field list'
MariaDB [libreria]> select editorial.codedit,editorial.nombre,liautedi.codedit1 from editorial right join liautedi on editorial.codedit=liautedi.codedit1;
+---------+--------------+----------+
| codedit | nombre       | codedit1 |
+---------+--------------+----------+
| E01     | Oveja Negra  | E01      |
| E01     | Oveja Negra  | E01      |
| E02     | Norma        | E02      |
| E02     | Norma        | E02      |
| E03     | Mc Graw Hill | E03      |
| E03     | Mc Graw Hill | E03      |
+---------+--------------+----------+
6 rows in set (0.004 sec)

MariaDB [libreria]> select distinct editorial.codedit,editorial.nombre,liautedi.codedit1 from editorial right join liautedi on editorial.codedit=liautedi.codedit1;
+---------+--------------+----------+
| codedit | nombre       | codedit1 |
+---------+--------------+----------+
| E01     | Oveja Negra  | E01      |
| E02     | Norma        | E02      |
| E03     | Mc Graw Hill | E03      |
+---------+--------------+----------+
3 rows in set (0.001 sec)

MariaDB [libreria]> select libro.titulo 'Libro',autor.nombre 'Autor',editorial.nombre 'Editorial' from libro inner join liautedi on libro.id_libro=liautedi.id_libro1 inner join autor on liautedi.codaut1=autor.codaut inner join editorial on liautedi.codedit1=editorial.codedit;
+----------------+---------------------+--------------+
| Libro          | Autor               | Editorial    |
+----------------+---------------------+--------------+
| Bd II          | Luis Joyanes        | Oveja Negra  |
| Ingl‚s         | Riaz Khadem         | Oveja Negra  |
| Contabilidad I | Jorge Vaquez Posada | Norma        |
| Ingl‚s         | Riaz Khadem         | Norma        |
| Bd II          | Robert Lorber       | Mc Graw Hill |
| Ingl‚s         | Riaz Khadem         | Mc Graw Hill |
+----------------+---------------------+--------------+
6 rows in set (0.001 sec)

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

MariaDB [libreria]> exit