MariaDB [clasejoin]> show table; 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 '' at line 1 MariaDB [clasejoin]> show tables; +---------------------+ | Tables_in_clasejoin | +---------------------+ | editorial | | libro | +---------------------+ 2 rows in set (0.001 sec) MariaDB [clasejoin]> select * from editorial; +--------+-------------+ | codigo | nombre | +--------+-------------+ | 1 | Voluntad | | 2 | Norma | | 3 | Oveja Negra | | 4 | RGB | | 5 | El c˘ndor | +--------+-------------+ 5 rows in set (0.001 sec) MariaDB [clasejoin]> select * from libro; +-----+-----------------------------+-----------------------+-----------------+--------+----------+ | cod | titulo | autor | codigoeditorial | precio | cantidad | +-----+-----------------------------+-----------------------+-----------------+--------+----------+ | 1 | El principito | Roberto Carlos Roa | 1 | 56000 | 3 | | 2 | la cenicienta | Rigoberto Colorado | 1 | 86000 | 3 | | 3 | la celestina | Javier Ospina Moreno | 2 | 30000 | 3 | | 4 | Cien Largos Cabellos | Javier Ospina Moreno | 3 | 25000 | 3 | | 5 | Catabuffer | Mauricio Ospina L˘pez | 3 | 125000 | 1 | | 6 | Tormenta | Ruben Villa | 4 | 27000 | 2 | | 7 | Angel la ni¤a de las flores | Jos‚ Apolinar | 1 | 15600 | 1 | | 8 | El celoso | Carlos Buitrago | 2 | 19600 | 2 | +-----+-----------------------------+-----------------------+-----------------+--------+----------+ 8 rows in set (0.004 sec) MariaDB [clasejoin]> show create table libro; +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | libro | CREATE TABLE `libro` ( `cod` int(10) unsigned NOT NULL AUTO_INCREMENT, `titulo` char(40) NOT NULL, `autor` char(30) NOT NULL DEFAULT 'Desconocido', `codigoeditorial` tinyint(3) unsigned NOT NULL, `precio` int(11) NOT NULL, `cantidad` smallint(5) unsigned DEFAULT 0, PRIMARY KEY (`cod`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci | +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [clasejoin]> show create table editorial; +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | editorial | CREATE TABLE `editorial` ( `codigo` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `nombre` char(20) NOT NULL, PRIMARY KEY (`codigo`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [clasejoin]> select * from editorial; +--------+-------------+ | codigo | nombre | +--------+-------------+ | 1 | Voluntad | | 2 | Norma | | 3 | Oveja Negra | | 4 | RGB | | 5 | El c˘ndor | +--------+-------------+ 5 rows in set (0.000 sec) MariaDB [clasejoin]> select * from libro; +-----+-----------------------------+-----------------------+-----------------+--------+----------+ | cod | titulo | autor | codigoeditorial | precio | cantidad | +-----+-----------------------------+-----------------------+-----------------+--------+----------+ | 1 | El principito | Roberto Carlos Roa | 1 | 56000 | 3 | | 2 | la cenicienta | Rigoberto Colorado | 1 | 86000 | 3 | | 3 | la celestina | Javier Ospina Moreno | 2 | 30000 | 3 | | 4 | Cien Largos Cabellos | Javier Ospina Moreno | 3 | 25000 | 3 | | 5 | Catabuffer | Mauricio Ospina L˘pez | 3 | 125000 | 1 | | 6 | Tormenta | Ruben Villa | 4 | 27000 | 2 | | 7 | Angel la ni¤a de las flores | Jos‚ Apolinar | 1 | 15600 | 1 | | 8 | El celoso | Carlos Buitrago | 2 | 19600 | 2 | +-----+-----------------------------+-----------------------+-----------------+--------+----------+ 8 rows in set (0.000 sec) MariaDB [clasejoin]> select e.nombre "EDITORIAL",l.titulo "NOMBRE DEL LIBRO" -> from editorial as e -> left join libro as l -> on e.codigo=l.codigoeditorial -> where l.codigoeditorial is not null; +-------------+-----------------------------+ | EDITORIAL | NOMBRE DEL LIBRO | +-------------+-----------------------------+ | Voluntad | El principito | | Voluntad | la cenicienta | | Norma | la celestina | | Oveja Negra | Cien Largos Cabellos | | Oveja Negra | Catabuffer | | RGB | Tormenta | | Voluntad | Angel la ni¤a de las flores | | Norma | El celoso | +-------------+-----------------------------+ 8 rows in set (0.000 sec) MariaDB [clasejoin]> select e.nombre "EDITORIAL",l.titulo "NOMBRE DEL LIBRO" -> from editorial as e -> left join libro as l -> on e.codigo=l.codigoeditorial -> where l.codigoeditorial is not null order by e.nombre desc; +-------------+-----------------------------+ | EDITORIAL | NOMBRE DEL LIBRO | +-------------+-----------------------------+ | Voluntad | El principito | | Voluntad | la cenicienta | | Voluntad | Angel la ni¤a de las flores | | RGB | Tormenta | | Oveja Negra | Cien Largos Cabellos | | Oveja Negra | Catabuffer | | Norma | El celoso | | Norma | la celestina | +-------------+-----------------------------+ 8 rows in set (0.001 sec) MariaDB [clasejoin]> select e.nombre "EDITORIAL",l.titulo "NOMBRE DEL LIBRO" from editorial as e -> left join libro as l -> on e.codigo=l.codigoeditorial -> where l.codigoeditorial is null; +-----------+------------------+ | EDITORIAL | NOMBRE DEL LIBRO | +-----------+------------------+ | El c˘ndor | NULL | +-----------+------------------+ 1 row in set (0.000 sec) MariaDB [clasejoin]> select nombre "EDITORIAL",titulo "NOMBRE DEL LIBRO" from libro as l -> right join editorial as e -> on e.codigo=l.codigoeditorial; +-------------+-----------------------------+ | EDITORIAL | NOMBRE DEL LIBRO | +-------------+-----------------------------+ | Voluntad | El principito | | Voluntad | la cenicienta | | Norma | la celestina | | Oveja Negra | Cien Largos Cabellos | | Oveja Negra | Catabuffer | | RGB | Tormenta | | Voluntad | Angel la ni¤a de las flores | | Norma | El celoso | | El c˘ndor | NULL | +-------------+-----------------------------+ 9 rows in set (0.000 sec) MariaDB [clasejoin]> select l.*,e.* -> from libro as l -> cross join editorial as e; +-----+-----------------------------+-----------------------+-----------------+--------+----------+--------+-------------+ | cod | titulo | autor | codigoeditorial | precio | cantidad | codigo | nombre | +-----+-----------------------------+-----------------------+-----------------+--------+----------+--------+-------------+ | 1 | El principito | Roberto Carlos Roa | 1 | 56000 | 3 | 1 | Voluntad | | 1 | El principito | Roberto Carlos Roa | 1 | 56000 | 3 | 2 | Norma | | 1 | El principito | Roberto Carlos Roa | 1 | 56000 | 3 | 3 | Oveja Negra | | 1 | El principito | Roberto Carlos Roa | 1 | 56000 | 3 | 4 | RGB | | 1 | El principito | Roberto Carlos Roa | 1 | 56000 | 3 | 5 | El c˘ndor | | 2 | la cenicienta | Rigoberto Colorado | 1 | 86000 | 3 | 1 | Voluntad | | 2 | la cenicienta | Rigoberto Colorado | 1 | 86000 | 3 | 2 | Norma | | 2 | la cenicienta | Rigoberto Colorado | 1 | 86000 | 3 | 3 | Oveja Negra | | 2 | la cenicienta | Rigoberto Colorado | 1 | 86000 | 3 | 4 | RGB | | 2 | la cenicienta | Rigoberto Colorado | 1 | 86000 | 3 | 5 | El c˘ndor | | 3 | la celestina | Javier Ospina Moreno | 2 | 30000 | 3 | 1 | Voluntad | | 3 | la celestina | Javier Ospina Moreno | 2 | 30000 | 3 | 2 | Norma | | 3 | la celestina | Javier Ospina Moreno | 2 | 30000 | 3 | 3 | Oveja Negra | | 3 | la celestina | Javier Ospina Moreno | 2 | 30000 | 3 | 4 | RGB | | 3 | la celestina | Javier Ospina Moreno | 2 | 30000 | 3 | 5 | El c˘ndor | | 4 | Cien Largos Cabellos | Javier Ospina Moreno | 3 | 25000 | 3 | 1 | Voluntad | | 4 | Cien Largos Cabellos | Javier Ospina Moreno | 3 | 25000 | 3 | 2 | Norma | | 4 | Cien Largos Cabellos | Javier Ospina Moreno | 3 | 25000 | 3 | 3 | Oveja Negra | | 4 | Cien Largos Cabellos | Javier Ospina Moreno | 3 | 25000 | 3 | 4 | RGB | | 4 | Cien Largos Cabellos | Javier Ospina Moreno | 3 | 25000 | 3 | 5 | El c˘ndor | | 5 | Catabuffer | Mauricio Ospina L˘pez | 3 | 125000 | 1 | 1 | Voluntad | | 5 | Catabuffer | Mauricio Ospina L˘pez | 3 | 125000 | 1 | 2 | Norma | | 5 | Catabuffer | Mauricio Ospina L˘pez | 3 | 125000 | 1 | 3 | Oveja Negra | | 5 | Catabuffer | Mauricio Ospina L˘pez | 3 | 125000 | 1 | 4 | RGB | | 5 | Catabuffer | Mauricio Ospina L˘pez | 3 | 125000 | 1 | 5 | El c˘ndor | | 6 | Tormenta | Ruben Villa | 4 | 27000 | 2 | 1 | Voluntad | | 6 | Tormenta | Ruben Villa | 4 | 27000 | 2 | 2 | Norma | | 6 | Tormenta | Ruben Villa | 4 | 27000 | 2 | 3 | Oveja Negra | | 6 | Tormenta | Ruben Villa | 4 | 27000 | 2 | 4 | RGB | | 6 | Tormenta | Ruben Villa | 4 | 27000 | 2 | 5 | El c˘ndor | | 7 | Angel la ni¤a de las flores | Jos‚ Apolinar | 1 | 15600 | 1 | 1 | Voluntad | | 7 | Angel la ni¤a de las flores | Jos‚ Apolinar | 1 | 15600 | 1 | 2 | Norma | | 7 | Angel la ni¤a de las flores | Jos‚ Apolinar | 1 | 15600 | 1 | 3 | Oveja Negra | | 7 | Angel la ni¤a de las flores | Jos‚ Apolinar | 1 | 15600 | 1 | 4 | RGB | | 7 | Angel la ni¤a de las flores | Jos‚ Apolinar | 1 | 15600 | 1 | 5 | El c˘ndor | | 8 | El celoso | Carlos Buitrago | 2 | 19600 | 2 | 1 | Voluntad | | 8 | El celoso | Carlos Buitrago | 2 | 19600 | 2 | 2 | Norma | | 8 | El celoso | Carlos Buitrago | 2 | 19600 | 2 | 3 | Oveja Negra | | 8 | El celoso | Carlos Buitrago | 2 | 19600 | 2 | 4 | RGB | | 8 | El celoso | Carlos Buitrago | 2 | 19600 | 2 | 5 | El c˘ndor | +-----+-----------------------------+-----------------------+-----------------+--------+----------+--------+-------------+ 40 rows in set (0.000 sec) MariaDB [clasejoin]> select l.titulo,e.nombre, -> l.precio+l.precio as total -> from libro as l -> cross join editorial as e; +-----------------------------+-------------+--------+ | titulo | nombre | total | +-----------------------------+-------------+--------+ | El principito | Voluntad | 112000 | | El principito | Norma | 112000 | | El principito | Oveja Negra | 112000 | | El principito | RGB | 112000 | | El principito | El c˘ndor | 112000 | | la cenicienta | Voluntad | 172000 | | la cenicienta | Norma | 172000 | | la cenicienta | Oveja Negra | 172000 | | la cenicienta | RGB | 172000 | | la cenicienta | El c˘ndor | 172000 | | la celestina | Voluntad | 60000 | | la celestina | Norma | 60000 | | la celestina | Oveja Negra | 60000 | | la celestina | RGB | 60000 | | la celestina | El c˘ndor | 60000 | | Cien Largos Cabellos | Voluntad | 50000 | | Cien Largos Cabellos | Norma | 50000 | | Cien Largos Cabellos | Oveja Negra | 50000 | | Cien Largos Cabellos | RGB | 50000 | | Cien Largos Cabellos | El c˘ndor | 50000 | | Catabuffer | Voluntad | 250000 | | Catabuffer | Norma | 250000 | | Catabuffer | Oveja Negra | 250000 | | Catabuffer | RGB | 250000 | | Catabuffer | El c˘ndor | 250000 | | Tormenta | Voluntad | 54000 | | Tormenta | Norma | 54000 | | Tormenta | Oveja Negra | 54000 | | Tormenta | RGB | 54000 | | Tormenta | El c˘ndor | 54000 | | Angel la ni¤a de las flores | Voluntad | 31200 | | Angel la ni¤a de las flores | Norma | 31200 | | Angel la ni¤a de las flores | Oveja Negra | 31200 | | Angel la ni¤a de las flores | RGB | 31200 | | Angel la ni¤a de las flores | El c˘ndor | 31200 | | El celoso | Voluntad | 39200 | | El celoso | Norma | 39200 | | El celoso | Oveja Negra | 39200 | | El celoso | RGB | 39200 | | El celoso | El c˘ndor | 39200 | +-----------------------------+-------------+--------+ 40 rows in set (0.001 sec) MariaDB [clasejoin]> select titulo,nombre -> from libro as l -> natural join editorial as e; +-----------------------------+-------------+ | titulo | nombre | +-----------------------------+-------------+ | El principito | Voluntad | | El principito | Norma | | El principito | Oveja Negra | | El principito | RGB | | El principito | El c˘ndor | | la cenicienta | Voluntad | | la cenicienta | Norma | | la cenicienta | Oveja Negra | | la cenicienta | RGB | | la cenicienta | El c˘ndor | | la celestina | Voluntad | | la celestina | Norma | | la celestina | Oveja Negra | | la celestina | RGB | | la celestina | El c˘ndor | | Cien Largos Cabellos | Voluntad | | Cien Largos Cabellos | Norma | | Cien Largos Cabellos | Oveja Negra | | Cien Largos Cabellos | RGB | | Cien Largos Cabellos | El c˘ndor | | Catabuffer | Voluntad | | Catabuffer | Norma | | Catabuffer | Oveja Negra | | Catabuffer | RGB | | Catabuffer | El c˘ndor | | Tormenta | Voluntad | | Tormenta | Norma | | Tormenta | Oveja Negra | | Tormenta | RGB | | Tormenta | El c˘ndor | | Angel la ni¤a de las flores | Voluntad | | Angel la ni¤a de las flores | Norma | | Angel la ni¤a de las flores | Oveja Negra | | Angel la ni¤a de las flores | RGB | | Angel la ni¤a de las flores | El c˘ndor | | El celoso | Voluntad | | El celoso | Norma | | El celoso | Oveja Negra | | El celoso | RGB | | El celoso | El c˘ndor | +-----------------------------+-------------+ 40 rows in set (0.000 sec) MariaDB [clasejoin]> select nombre,titulo -> from editorial as e -> join libro as l -> on e.codigo=l.codigoeditorial; +-------------+-----------------------------+ | nombre | titulo | +-------------+-----------------------------+ | Voluntad | El principito | | Voluntad | la cenicienta | | Norma | la celestina | | Oveja Negra | Cien Largos Cabellos | | Oveja Negra | Catabuffer | | RGB | Tormenta | | Voluntad | Angel la ni¤a de las flores | | Norma | El celoso | +-------------+-----------------------------+ 8 rows in set (0.001 sec) MariaDB [clasejoin]> select min(precio) from libro; +-------------+ | min(precio) | +-------------+ | 15600 | +-------------+ 1 row in set (0.000 sec) MariaDB [clasejoin]> select @menorprecio:=min(precio) from libro; +---------------------------+ | @menorprecio:=min(precio) | +---------------------------+ | 15600 | +---------------------------+ 1 row in set (0.000 sec) MariaDB [clasejoin]> select * from libro -> where precio=@menorprecio; +-----+-----------------------------+---------------+-----------------+--------+----------+ | cod | titulo | autor | codigoeditorial | precio | cantidad | +-----+-----------------------------+---------------+-----------------+--------+----------+ | 7 | Angel la ni¤a de las flores | Jos‚ Apolinar | 1 | 15600 | 1 | +-----+-----------------------------+---------------+-----------------+--------+----------+ 1 row in set (0.000 sec) MariaDB [clasejoin]> select @editorial:=e.nombre -> from libro as l -> join editorial as e -> on l.codigoeditorial=e.codigo -> where precio=@menorprecio; +----------------------+ | @editorial:=e.nombre | +----------------------+ | Voluntad | +----------------------+ 1 row in set (0.000 sec) MariaDB [clasejoin]> select @editorial:=e.nombre, @libro:=l.titulo -> from libro as l -> join editorial as e -> on l.codigoeditorial=e.codigo -> where precio=@menorprecio; +----------------------+-----------------------------+ | @editorial:=e.nombre | @libro:=l.titulo | +----------------------+-----------------------------+ | Voluntad | Angel la ni¤a de las flores | +----------------------+-----------------------------+ 1 row in set (0.000 sec) MariaDB [clasejoin]> select @editorial:=e.nombre as nombre, @libro:=l.titulo as titulo -> from libro as l -> join editorial as e -> on l.codigoeditorial=e.codigo -> where precio=@menorprecio; +----------+-----------------------------+ | nombre | titulo | +----------+-----------------------------+ | Voluntad | Angel la ni¤a de las flores | +----------+-----------------------------+ 1 row in set (0.001 sec) MariaDB [clasejoin]> exit