MariaDB [libreria]> show tables; +--------------------+ | Tables_in_libreria | +--------------------+ | asignatura | | autor | | editorial | | liautedi | | libro | +--------------------+ 5 rows in set (0.000 sec) MariaDB [libreria]> describe libro; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | idlibro | varchar(10) | NO | PRI | NULL | | | descripcion | varchar(50) | NO | | NULL | | | nropagina | int(8) | NO | | NULL | | | precio | int(8) | NO | | NULL | | | codigomat | varchar(10) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 5 rows in set (0.011 sec) MariaDB [libreria]> select distinct libro.idlibro,libro.descripcion,autor.codautor,autor.nombre from libro inner join liautedi on libro.idlibro=liautedi.idlibro inner join autor on liautedi.codautor=autor.codautor; +---------+----------------+----------+----------------------+ | idlibro | descripcion | codautor | nombre | +---------+----------------+----------+----------------------+ | L02 | BD II | A01 | Luis Joyanes | | L02 | BD II | A05 | Robert Lorber | | L06 | Contabilidad I | A02 | Jorge Vasquez Posada | | L07 | Redes | A05 | Robert Lorber | | L04 | Ingles | A04 | Riaz Khadem | +---------+----------------+----------+----------------------+ 5 rows in set (0.004 sec) MariaDB [libreria]> select distinct libro.idlibro,libro.descripcion,editorial.codedit,editorial.nombre from libro inner join liautedi on libro.idlibro=liautedi.idlibro inner join editorial on liautedi.codedit=editorial.codedit; +---------+----------------+---------+--------------+ | idlibro | descripcion | codedit | nombre | +---------+----------------+---------+--------------+ | L02 | BD II | E01 | Oveja Negra | | L04 | Ingles | E01 | Oveja Negra | | L06 | Contabilidad I | E02 | Norma | | L04 | Ingles | E02 | Norma | | L02 | BD II | E03 | Mc Graw Hill | | L07 | Redes | E03 | Mc Graw Hill | | L04 | Ingles | E03 | Mc Graw Hill | +---------+----------------+---------+--------------+ 7 rows in set (0.005 sec) MariaDB [libreria]> MariaDB [libreria]> MariaDB [libreria]> MariaDB [libreria]> MariaDB [libreria]> MariaDB [libreria]> select distinct libro.idlibro,libro.descripcion,editorial.codedit,editorial.nombre from libro inner join liautedi on libro.idlibro=liautedi.idlibro inner join editorial on liautedi.codedit=editorial.codedit into outfile 'c:/xampp/libroeditorialjoin.xls'; Query OK, 7 rows affected, 1 warning (0.001 sec) MariaDB [libreria]> select distinct libro.idlibro,libro.descripcion,editorial.codedit,editorial.nombre,autor.codautor,autor.nombre from libro inner join liautedi on libro.idlibro=liautedi.idlibro inner join editorial on liautedi.codedit=editorial.codedit inner join autor on autor.codautor=liautedi.codautor; +---------+----------------+---------+--------------+----------+----------------------+ | idlibro | descripcion | codedit | nombre | codautor | nombre | +---------+----------------+---------+--------------+----------+----------------------+ | L02 | BD II | E01 | Oveja Negra | A01 | Luis Joyanes | | L04 | Ingles | E01 | Oveja Negra | A04 | Riaz Khadem | | L06 | Contabilidad I | E02 | Norma | A02 | Jorge Vasquez Posada | | L04 | Ingles | E02 | Norma | A04 | Riaz Khadem | | L02 | BD II | E03 | Mc Graw Hill | A05 | Robert Lorber | | L07 | Redes | E03 | Mc Graw Hill | A05 | Robert Lorber | | L04 | Ingles | E03 | Mc Graw Hill | A04 | Riaz Khadem | +---------+----------------+---------+--------------+----------+----------------------+ 7 rows in set (0.001 sec) MariaDB [libreria]> MariaDB [libreria]> MariaDB [libreria]> MariaDB [libreria]> MariaDB [libreria]> MariaDB [libreria]> select libro.idlibro,libro.descripcion,editorial.codedit,editorial.nombre,autor.codautor,autor.nombre from libro inner join liautedi on libro.idlibro=liautedi.idlibro inner join editorial on liautedi.codedit=editorial.codedit inner join autor on autor.codautor=liautedi.codautor; +---------+----------------+---------+--------------+----------+----------------------+ | idlibro | descripcion | codedit | nombre | codautor | nombre | +---------+----------------+---------+--------------+----------+----------------------+ | L02 | BD II | E01 | Oveja Negra | A01 | Luis Joyanes | | L04 | Ingles | E01 | Oveja Negra | A04 | Riaz Khadem | | L06 | Contabilidad I | E02 | Norma | A02 | Jorge Vasquez Posada | | L04 | Ingles | E02 | Norma | A04 | Riaz Khadem | | L02 | BD II | E03 | Mc Graw Hill | A05 | Robert Lorber | | L07 | Redes | E03 | Mc Graw Hill | A05 | Robert Lorber | | L04 | Ingles | E03 | Mc Graw Hill | A04 | Riaz Khadem | +---------+----------------+---------+--------------+----------+----------------------+ 7 rows in set (0.000 sec) MariaDB [libreria]> select libro.idlibro,libro.descripcion,editorial.codedit,editorial.nombre,autor.codautor,autor.nombre from libro inner join liautedi on libro.idlibro=liautedi.idlibro inner join editorial on liautedi.codedit=editorial.codedit inner join autor on autor.codautor=liautedi.codautor into outfile 'c:/xampp/libroautoreditorialjoin.xls'; Query OK, 7 rows affected, 1 warning (0.001 sec) MariaDB [libreria]> select * from libro; +---------+---------------------+-----------+--------+-----------+ | idlibro | descripcion | nropagina | precio | codigomat | +---------+---------------------+-----------+--------+-----------+ | L01 | Calculo II | 120 | 55000 | M01 | | L02 | BD II | 150 | 65000 | M09 | | L03 | Estructura de datos | 180 | 85000 | M03 | | L04 | Ingles | 280 | 105000 | M04 | | L05 | Admon en una pagina | 70 | 7500 | M05 | | L06 | Contabilidad I | 170 | 27500 | M06 | | L07 | Redes | 370 | 32500 | M07 | | L08 | Diagramacion | 85 | 45000 | M08 | +---------+---------------------+-----------+--------+-----------+ 8 rows in set (0.000 sec) MariaDB [libreria]> select * from liautedi; +---------+----------+---------+ | idlibro | codautor | codedit | +---------+----------+---------+ | 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.idlibro,libro.descripcion,liautedi.idlibro from libro left join liautedi on libro.idlibro=liautedi.idlibro where liautedi.idlibro is null; +---------+---------------------+---------+ | idlibro | descripcion | idlibro | +---------+---------------------+---------+ | L01 | Calculo II | NULL | | L03 | Estructura de datos | NULL | | L05 | Admon en una pagina | NULL | | L08 | Diagramacion | NULL | +---------+---------------------+---------+ 4 rows in set (0.000 sec) MariaDB [libreria]> select libro.idlibro,libro.descripcion,liautedi.idlibro from libro left join liautedi on libro.idlibro=liautedi.idlibro where liautedi.idlibro is nullinto outfile 'c:/xampp/libross_sin_autor.xls'; 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 'nullinto outfile 'c:/xampp/libross_sin_autor.xls'' at line 1 MariaDB [libreria]> select libro.idlibro,libro.descripcion,liautedi.idlibro from libro left join liautedi on libro.idlibro=liautedi.idlibro where liautedi.idlibro is null into outfile 'c:/xampp/librosssinautor.xls'; Query OK, 4 rows affected, 1 warning (0.001 sec) MariaDB [libreria]> select autor.codautor,autor.nombre,liautedi.codautor from autor left join liautedi on autor.codautor=liautedi.codautor where liautedi.codautor is null ; +----------+-------------+----------+ | codautor | nombre | codautor | +----------+-------------+----------+ | A03 | Jhon Soars | NULL | | A06 | Mario Dream | NULL | +----------+-------------+----------+ 2 rows in set (0.000 sec) MariaDB [libreria]> select autor.codautor,autor.nombre,liautedi.codautor from autor left join liautedi on autor.codautor=liautedi.codautor where liautedi.codautor is null into outfile 'c:/xampp/autoressinlibros.xls'; Query OK, 2 rows affected, 1 warning (0.001 sec) MariaDB [libreria]> select libro.idlibro,libro.descripcion,liautedi.idlibro from libro right join liautedi on libro.idlibro=liautedi.idlibro; +---------+----------------+---------+ | idlibro | descripcion | idlibro | +---------+----------------+---------+ | L02 | BD II | L02 | | L02 | BD II | L02 | | L04 | Ingles | L04 | | L04 | Ingles | L04 | | L04 | Ingles | L04 | | L06 | Contabilidad I | L06 | | L07 | Redes | L07 | +---------+----------------+---------+ 7 rows in set (0.000 sec) MariaDB [libreria]> MariaDB [libreria]> MariaDB [libreria]> select libro.idlibro,libro.descripcion,autor.codautor,autor.nombre from libro left join liautedi on libro.idlibro=liautedi.idlibro left join autor on liautedi.codautor=autor.codautor; +---------+---------------------+----------+----------------------+ | idlibro | descripcion | codautor | nombre | +---------+---------------------+----------+----------------------+ | L01 | Calculo II | NULL | NULL | | L02 | BD II | A01 | Luis Joyanes | | L02 | BD II | A05 | Robert Lorber | | L03 | Estructura de datos | NULL | NULL | | L04 | Ingles | A04 | Riaz Khadem | | L04 | Ingles | A04 | Riaz Khadem | | L04 | Ingles | A04 | Riaz Khadem | | L05 | Admon en una pagina | NULL | NULL | | L06 | Contabilidad I | A02 | Jorge Vasquez Posada | | L07 | Redes | A05 | Robert Lorber | | L08 | Diagramacion | NULL | NULL | +---------+---------------------+----------+----------------------+ 11 rows in set (0.000 sec) MariaDB [libreria]> select libro.idlibro,libro.descripcion,autor.codautor,autor.nombre from libro left right liautedi on libro.idlibro=liautedi.idlibro right join autor on liautedi.codautor=autor.codautor; 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 'right liautedi on libro.idlibro=liautedi.idlibro right join autor on liaute...' at line 1