MariaDB [(none)]> MariaDB [(none)]> Source C:\Users\Vanessa\Desktop\Final Base de Datos\ConsultasGimnasio.sql Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Database changed Query OK, 0 rows affected (0.19 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 4 rows affected (0.00 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 8 rows affected (0.01 sec) Records: 8 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 4 rows affected (0.00 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.12 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.07 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 10 rows affected (0.00 sec) Records: 10 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.09 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.09 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 4 rows affected (0.00 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.17 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 10 rows affected (0.00 sec) Records: 10 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.05 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 4 rows affected (0.00 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 10 rows affected (0.00 sec) Records: 10 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) MariaDB [Gimnasio]> MariaDB [Gimnasio]> MariaDB [Gimnasio]> SELECT * FROM T_TIPOS_IDENTIFICACION; +-------------------------+-------------------------+ | IDE_TIPO_IDENTIFICACION | NOM_TIPO_IDENTIFICACION | +-------------------------+-------------------------+ | CC | Cedula Identificaci˝n | | TI | Tarjeta de Identidad | +-------------------------+-------------------------+ 2 rows in set (0.02 sec) MariaDB [Gimnasio]> MariaDB [Gimnasio]> SELECT U.IDE_TIPO_IDENTIFICACION, -> E.NOMBRE -> FROM T_USUARIOS U -> INNER JOIN T_USUARIOS U ON U.IDE_TIPO_IDENTIFICACION = E.IDE_TIPO_IDENTIFICACION -> INNER JOIN T_EMPLEADOS E ON E.NOMBRES = U.NOMBRES; ERROR 1066 (42000): Not unique table/alias: 'U' MariaDB [Gimnasio]> MariaDB [Gimnasio]> MariaDB [Gimnasio]> SELECT T_USUARIOS.IDE_TIPO_IDENTIFICACION, -> T_EMPLEADOS.NOMBRE -> FROM T_USUARIOS -> INNER JOIN T_USUARIOS ON T_USUARIOS.IDE_TIPO_IDENTIFICACION = T_EMPLEADOS.IDE_TIPO_IDENTIFICACION -> INNER JOIN T_EMPLEADOS ON T_EMPLEADOS.NOMBRES = T_USUARIOS.NOMBRES; ERROR 1066 (42000): Not unique table/alias: 'T_USUARIOS' MariaDB [Gimnasio]> MariaDB [Gimnasio]> MariaDB [Gimnasio]> SELECT T_USUARIOS.IDE_TIPO_IDENTIFICACION, -> T_USUARIOS.IDE_ESTADO, -> T_EMPLEADOS.IDE_PROFESION, -> T_EMPLEADOS.NUM_IDENTIFICACION -> FROM T_USUARIOS -> INNER JOIN T_TIPOS_IDENTIFICACION ON T_USUARIOS.IDE_TIPO_IDENTIFICACION = T_TIPOS_IDENTIFICACION.IDE_TIPO_IDENTIFICACION -> INNER JOIN T_PROFESIONES ON T_PROFESIONES.IDE_PROFESION = T_EMPLEADOS.IDE_PROFESION; ERROR 1054 (42S22): Unknown column 'T_EMPLEADOS.IDE_PROFESION' in 'field list' MariaDB [Gimnasio]> MariaDB [Gimnasio]> MariaDB [Gimnasio]> SELECT * FROM T_EMPLEADOS; +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ | IDE_EMPLEADO | NUM_IDENTIFICACION | NOMBRES | APELLIDO1 | APELLIDO2 | DIRECCION | TEL_FIJO | TEL_MOVIL | FEC_INGRESO | IDE_CARGO | ACTIVO | FEC_NACIMIENTO | SEXO | IDE_TIPO_IDENTIFICACION | EMAIL | SALARIO | IDE_PROFESION | DES_PERFIL | +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ | 1 | 1020481780 | Leidy Vanessa | Gutierrez | Hoyos | Barrio la pradera | 5846069 | 3004533498 | 0000-00-00 | 1 | S | 0000-00-00 | F | CC | estebacardona@gmail.com | 1500000 | 2 | Musculo | | 2 | 15510309 | Juliana | Salazar | Fernandez | Barrio rosaleda | 5882104 | 31202122121 | 0000-00-00 | 2 | S | 0000-00-00 | F | CC | dianapatricia@gmail.com | 2500000 | 2 | Bajar de peso | | 3 | 182699765 | Diana | Restrepo | Mendez | Barrio Aragon | 5841998 | 3215414552 | 0000-00-00 | 3 | S | 0000-00-00 | F | CC | jorgezapata@gmail.com | 1000000 | 2 | Piernas | | 4 | 276618199 | William Dario | Casta¤eda | Hernandez | Barrio la pradera | 2791469 | 31748141112 | 0000-00-00 | 4 | S | 0000-00-00 | M | CC | jennyvelasquez@gmail.com | 600000 | 2 | Agdomen | | 5 | 367899090 | Amparo | Giraldo | Pati¤o | Urbanizacion compartir | 2868617 | 325541255 | 0000-00-00 | 1 | S | 0000-00-00 | F | CC | anaposada@gmail.com | 1500000 | 2 | Grasa | | 6 | 673568276 | Juanita | Suarez | Arrieta | Urbanizaci˘n ciudadela prado | 5841497 | 3011857414 | 0000-00-00 | 2 | S | 0000-00-00 | F | CC | indiraortiz@gmail.com | 800000 | 2 | Cardio | | 7 | 182729998 | Walter | Lopez | Pareja | Barrio Sangabriel | 5840570 | 301485120 | 0000-00-00 | 3 | S | 0000-00-00 | M | CC | adrianaquintero@gmail.com | 1500000 | 2 | Aerobicos | | 8 | 103087267 | Stiven | Vergara | Mira | Barrio la pradera | 3767289 | 312485541 | 0000-00-00 | 4 | S | 0000-00-00 | M | CC | edilmamontoya@gmail.com | 2500000 | 2 | Grasa | +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ 8 rows in set (0.00 sec) MariaDB [Gimnasio]> SET LINE 600 -> ; ERROR 1193 (HY000): Unknown system variable 'LINE' MariaDB [Gimnasio]> MariaDB [Gimnasio]> SELECT * FROM T_EMPLEADOS; +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ | IDE_EMPLEADO | NUM_IDENTIFICACION | NOMBRES | APELLIDO1 | APELLIDO2 | DIRECCION | TEL_FIJO | TEL_MOVIL | FEC_INGRESO | IDE_CARGO | ACTIVO | FEC_NACIMIENTO | SEXO | IDE_TIPO_IDENTIFICACION | EMAIL | SALARIO | IDE_PROFESION | DES_PERFIL | +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ | 1 | 1020481780 | Leidy Vanessa | Gutierrez | Hoyos | Barrio la pradera | 5846069 | 3004533498 | 0000-00-00 | 1 | S | 0000-00-00 | F | CC | estebacardona@gmail.com | 1500000 | 2 | Musculo | | 2 | 15510309 | Juliana | Salazar | Fernandez | Barrio rosaleda | 5882104 | 31202122121 | 0000-00-00 | 2 | S | 0000-00-00 | F | CC | dianapatricia@gmail.com | 2500000 | 2 | Bajar de peso | | 3 | 182699765 | Diana | Restrepo | Mendez | Barrio Aragon | 5841998 | 3215414552 | 0000-00-00 | 3 | S | 0000-00-00 | F | CC | jorgezapata@gmail.com | 1000000 | 2 | Piernas | | 4 | 276618199 | William Dario | Casta¤eda | Hernandez | Barrio la pradera | 2791469 | 31748141112 | 0000-00-00 | 4 | S | 0000-00-00 | M | CC | jennyvelasquez@gmail.com | 600000 | 2 | Agdomen | | 5 | 367899090 | Amparo | Giraldo | Pati¤o | Urbanizacion compartir | 2868617 | 325541255 | 0000-00-00 | 1 | S | 0000-00-00 | F | CC | anaposada@gmail.com | 1500000 | 2 | Grasa | | 6 | 673568276 | Juanita | Suarez | Arrieta | Urbanizaci˘n ciudadela prado | 5841497 | 3011857414 | 0000-00-00 | 2 | S | 0000-00-00 | F | CC | indiraortiz@gmail.com | 800000 | 2 | Cardio | | 7 | 182729998 | Walter | Lopez | Pareja | Barrio Sangabriel | 5840570 | 301485120 | 0000-00-00 | 3 | S | 0000-00-00 | M | CC | adrianaquintero@gmail.com | 1500000 | 2 | Aerobicos | | 8 | 103087267 | Stiven | Vergara | Mira | Barrio la pradera | 3767289 | 312485541 | 0000-00-00 | 4 | S | 0000-00-00 | M | CC | edilmamontoya@gmail.com | 2500000 | 2 | Grasa | +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ 8 rows in set (0.00 sec) MariaDB [Gimnasio]> MariaDB [Gimnasio]> MariaDB [Gimnasio]> SELECT * FROM T_PROFESIONES; +---------------+---------------+ | IDE_PROFESION | DES_PROFESION | +---------------+---------------+ | 1 | Ingeniero | | 2 | Doctor | | 3 | Odontologo | | 4 | Mesero | | 5 | Cocinero | | 6 | Civil | | 7 | Enfermero | | 8 | Obrero | | 9 | Contadora | | 10 | Desarrollador | +---------------+---------------+ 10 rows in set (0.02 sec) MariaDB [Gimnasio]> MariaDB [Gimnasio]> MariaDB [Gimnasio]> SELECT T_USUARIOS.IDE_TIPO_IDENTIFICACION, -> T_USUARIOS.IDE_ESTADO, -> T_EMPLEADOS.IDE_PROFESION, -> T_EMPLEADOS.NUM_IDENTIFICACION -> FROM T_USUARIOS -> INNER JOIN T_TIPOS_IDENTIFICACION ON T_USUARIOS.IDE_TIPO_IDENTIFICACION = T_TIPOS_IDENTIFICACION.IDE_TIPO_IDENTIFICACION; ERROR 1054 (42S22): Unknown column 'T_EMPLEADOS.IDE_PROFESION' in 'field list' MariaDB [Gimnasio]> MariaDB [Gimnasio]> SELECT T_USUARIOS.IDE_TIPO_IDENTIFICACION, -> T_USUARIOS.IDE_ESTADO, -> FROM T_USUARIOS -> INNER JOIN T_TIPOS_IDENTIFICACION ON T_USUARIOS.IDE_TIPO_IDENTIFICACION = T_TIPOS_IDENTIFICACION.IDE_TIPO_IDENTIFICACION; 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 'FROM T_USUARIOS INNER JOIN T_TIPOS_IDENTIFICACION ON T_USUARIOS.IDE_TIPO_IDENT' at line 3 MariaDB [Gimnasio]> MariaDB [(none)]> MariaDB [(none)]> Source C:\Users\Vanessa\Desktop\Final Base de Datos\ConsultasGimnasio.sql Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Database changed Query OK, 0 rows affected (0.05 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.18 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 4 rows affected (0.05 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.11 sec) Query OK, 0 rows affected (0.16 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.19 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.15 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.17 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.17 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.22 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.20 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.16 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.20 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.33 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.17 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.22 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 8 rows affected (0.05 sec) Records: 8 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.08 sec) Query OK, 0 rows affected (0.18 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.22 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 4 rows affected (0.05 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.17 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.19 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.17 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.20 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.18 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.18 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 10 rows affected (0.15 sec) Records: 10 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.18 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.20 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.14 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.20 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.16 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.17 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 4 rows affected (0.06 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.17 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.17 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.15 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.16 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 2 rows affected (0.04 sec) Records: 2 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.07 sec) Query OK, 0 rows affected (0.16 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.20 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 10 rows affected (0.04 sec) Records: 10 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.07 sec) Query OK, 0 rows affected (0.16 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.18 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.17 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.20 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.18 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.23 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 4 rows affected (0.10 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.16 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.23 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.14 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.20 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 2 rows affected (0.04 sec) Records: 2 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.08 sec) Query OK, 0 rows affected (0.16 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.25 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.17 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.21 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.16 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.18 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.17 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.40 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 10 rows affected (0.06 sec) Records: 10 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.09 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) MariaDB [Gimnasio]> MariaDB [Gimnasio]> MariaDB [Gimnasio]> MariaDB [Gimnasio]> MariaDB [Gimnasio]> SELECT T_USUARIOS.IDE_TIPO_IDENTIFICACION, -> T_USUARIOS.IDE_ESTADO, -> T_EMPLEADOS.IDE_PROFESION, -> T_EMPLEADOS.NUM_IDENTIFICACION -> FROM T_USUARIOS -> INNER JOIN T_TIPOS_IDENTIFICACION ON T_USUARIOS.IDE_TIPO_IDENTIFICACION = T_TIPOS_IDENTIFICACION.IDE_TIPO_IDENTIFICACION -> INNER JOIN T_PROFESIONES ON T_PROFESIONES.IDE_PROFESION = T_EMPLEADOS.IDE_PROFESION; ERROR 1054 (42S22): Unknown column 'T_EMPLEADOS.IDE_PROFESION' in 'field list' MariaDB [Gimnasio]> MariaDB [Gimnasio]> MariaDB [Gimnasio]> select * from t_empleados; +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ | IDE_EMPLEADO | NUM_IDENTIFICACION | NOMBRES | APELLIDO1 | APELLIDO2 | DIRECCION | TEL_FIJO | TEL_MOVIL | FEC_INGRESO | IDE_CARGO | ACTIVO | FEC_NACIMIENTO | SEXO | IDE_TIPO_IDENTIFICACION | EMAIL | SALARIO | IDE_PROFESION | DES_PERFIL | +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ | 1 | 1020481780 | Leidy Vanessa | Gutierrez | Hoyos | Barrio la pradera | 5846069 | 3004533498 | 0000-00-00 | 1 | S | 0000-00-00 | F | CC | estebacardona@gmail.com | 1500000 | 2 | Musculo | | 2 | 15510309 | Juliana | Salazar | Fernandez | Barrio rosaleda | 5882104 | 31202122121 | 0000-00-00 | 2 | S | 0000-00-00 | F | CC | dianapatricia@gmail.com | 2500000 | 2 | Bajar de peso | | 3 | 182699765 | Diana | Restrepo | Mendez | Barrio Aragon | 5841998 | 3215414552 | 0000-00-00 | 3 | S | 0000-00-00 | F | CC | jorgezapata@gmail.com | 1000000 | 2 | Piernas | | 4 | 276618199 | William Dario | Casta¤eda | Hernandez | Barrio la pradera | 2791469 | 31748141112 | 0000-00-00 | 4 | S | 0000-00-00 | M | CC | jennyvelasquez@gmail.com | 600000 | 2 | Agdomen | | 5 | 367899090 | Amparo | Giraldo | Pati¤o | Urbanizacion compartir | 2868617 | 325541255 | 0000-00-00 | 1 | S | 0000-00-00 | F | CC | anaposada@gmail.com | 1500000 | 2 | Grasa | | 6 | 673568276 | Juanita | Suarez | Arrieta | Urbanizaci˘n ciudadela prado | 5841497 | 3011857414 | 0000-00-00 | 2 | S | 0000-00-00 | F | CC | indiraortiz@gmail.com | 800000 | 2 | Cardio | | 7 | 182729998 | Walter | Lopez | Pareja | Barrio Sangabriel | 5840570 | 301485120 | 0000-00-00 | 3 | S | 0000-00-00 | M | CC | adrianaquintero@gmail.com | 1500000 | 2 | Aerobicos | | 8 | 103087267 | Stiven | Vergara | Mira | Barrio la pradera | 3767289 | 312485541 | 0000-00-00 | 4 | S | 0000-00-00 | M | CC | edilmamontoya@gmail.com | 2500000 | 2 | Grasa | +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ 8 rows in set (0.01 sec) MariaDB [Gimnasio]> MariaDB [Gimnasio]> SELECT T_USUARIOS.IDE_TIPO_IDENTIFICACION, -> T_USUARIOS.IDE_ESTADO, -> T_EMPLEADOS.IDE_PROFESION, -> T_EMPLEADOS.NUM_IDENTIFICACION -> FROM T_USUARIOS -> INNER JOIN T_TIPOS_IDENTIFICACION ON T_USUARIOS.IDE_TIPO_IDENTIFICACION = T_TIPOS_IDENTIFICACION.IDE_TIPO_IDENTIFICACION -> INNER JOIN T_PROFESIONES ON T_PROFESIONES.IDE_PROFESION = T_EMPLEADOS.IDE_PROFESION; ERROR 1054 (42S22): Unknown column 'T_EMPLEADOS.IDE_PROFESION' in 'field list' MariaDB [Gimnasio]> MariaDB [Gimnasio]> select * from t_empleados; +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ | IDE_EMPLEADO | NUM_IDENTIFICACION | NOMBRES | APELLIDO1 | APELLIDO2 | DIRECCION | TEL_FIJO | TEL_MOVIL | FEC_INGRESO | IDE_CARGO | ACTIVO | FEC_NACIMIENTO | SEXO | IDE_TIPO_IDENTIFICACION | EMAIL | SALARIO | IDE_PROFESION | DES_PERFIL | +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ | 1 | 1020481780 | Leidy Vanessa | Gutierrez | Hoyos | Barrio la pradera | 5846069 | 3004533498 | 0000-00-00 | 1 | S | 0000-00-00 | F | CC | estebacardona@gmail.com | 1500000 | 2 | Musculo | | 2 | 15510309 | Juliana | Salazar | Fernandez | Barrio rosaleda | 5882104 | 31202122121 | 0000-00-00 | 2 | S | 0000-00-00 | F | CC | dianapatricia@gmail.com | 2500000 | 2 | Bajar de peso | | 3 | 182699765 | Diana | Restrepo | Mendez | Barrio Aragon | 5841998 | 3215414552 | 0000-00-00 | 3 | S | 0000-00-00 | F | CC | jorgezapata@gmail.com | 1000000 | 2 | Piernas | | 4 | 276618199 | William Dario | Casta¤eda | Hernandez | Barrio la pradera | 2791469 | 31748141112 | 0000-00-00 | 4 | S | 0000-00-00 | M | CC | jennyvelasquez@gmail.com | 600000 | 2 | Agdomen | | 5 | 367899090 | Amparo | Giraldo | Pati¤o | Urbanizacion compartir | 2868617 | 325541255 | 0000-00-00 | 1 | S | 0000-00-00 | F | CC | anaposada@gmail.com | 1500000 | 2 | Grasa | | 6 | 673568276 | Juanita | Suarez | Arrieta | Urbanizaci˘n ciudadela prado | 5841497 | 3011857414 | 0000-00-00 | 2 | S | 0000-00-00 | F | CC | indiraortiz@gmail.com | 800000 | 2 | Cardio | | 7 | 182729998 | Walter | Lopez | Pareja | Barrio Sangabriel | 5840570 | 301485120 | 0000-00-00 | 3 | S | 0000-00-00 | M | CC | adrianaquintero@gmail.com | 1500000 | 2 | Aerobicos | | 8 | 103087267 | Stiven | Vergara | Mira | Barrio la pradera | 3767289 | 312485541 | 0000-00-00 | 4 | S | 0000-00-00 | M | CC | edilmamontoya@gmail.com | 2500000 | 2 | Grasa | +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ 8 rows in set (0.00 sec) MariaDB [Gimnasio]> describe t_empleados; +-------------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------------+-------------+------+-----+---------+-------+ | IDE_EMPLEADO | int(11) | NO | PRI | NULL | | | NUM_IDENTIFICACION | varchar(20) | NO | | NULL | | | NOMBRES | varchar(50) | NO | | NULL | | | APELLIDO1 | varchar(25) | NO | | NULL | | | APELLIDO2 | varchar(25) | YES | | NULL | | | DIRECCION | varchar(50) | NO | | NULL | | | TEL_FIJO | varchar(25) | NO | | NULL | | | TEL_MOVIL | varchar(25) | YES | | NULL | | | FEC_INGRESO | date | NO | | NULL | | | IDE_CARGO | int(11) | NO | MUL | NULL | | | ACTIVO | char(1) | YES | | S | | | FEC_NACIMIENTO | date | YES | | NULL | | | SEXO | char(1) | YES | | NULL | | | IDE_TIPO_IDENTIFICACION | varchar(5) | YES | MUL | NULL | | | EMAIL | varchar(80) | YES | | NULL | | | SALARIO | int(11) | YES | | NULL | | | IDE_PROFESION | int(11) | NO | MUL | NULL | | | DES_PERFIL | varchar(50) | NO | | NULL | | +-------------------------+-------------+------+-----+---------+-------+ 18 rows in set (0.06 sec) MariaDB [Gimnasio]> MariaDB [Gimnasio]> MariaDB [Gimnasio]> MariaDB [Gimnasio]> describe t_profesiones; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | IDE_PROFESION | int(11) | NO | PRI | NULL | | | DES_PROFESION | varchar(30) | NO | | NULL | | +---------------+-------------+------+-----+---------+-------+ 2 rows in set (0.03 sec) MariaDB [Gimnasio]> MariaDB [Gimnasio]> select * from t_profesiones; +---------------+---------------+ | IDE_PROFESION | DES_PROFESION | +---------------+---------------+ | 1 | Ingeniero | | 2 | Doctor | | 3 | Odontologo | | 4 | Mesero | | 5 | Cocinero | | 6 | Civil | | 7 | Enfermero | | 8 | Obrero | | 9 | Contadora | | 10 | Desarrollador | +---------------+---------------+ 10 rows in set (0.00 sec) MariaDB [Gimnasio]> select usu.IDE_TIPO_IDENTIFICACION,usu.nombre -> t_usuarios usu inner join t_profesiones pro -> on usu.IDE_PROFESION=pro.IDE_PROFESION -> -> where usu.NUM_IDENTIFICACION='1020481780'; 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 'usu inner join t_profesiones pro on usu.IDE_PROFESION=pro.IDE_PROFESION where' at line 2 MariaDB [Gimnasio]> MariaDB [Gimnasio]> select usu.IDE_TIPO_IDENTIFICACION,usu.nombre -> t_usuarios usu inner join t_profesiones pro -> on usu.IDE_PROFESION=pro.IDE_PROFESION -> -> on usu.IDE_PROFESION=pro.IDE_PROFESION; 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 'usu inner join t_profesiones pro on usu.IDE_PROFESION=pro.IDE_PROFESION on us' at line 2 MariaDB [Gimnasio]> select usu.IDE_TIPO_IDENTIFICACION,usu.nombre -> t_usuarios usu join t_profesiones pro -> on usu.IDE_PROFESION=pro.IDE_PROFESION -> -> where usu.NUM_IDENTIFICACION='1020481780'; 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 'usu join t_profesiones pro on usu.IDE_PROFESION=pro.IDE_PROFESION where usu.' at line 2 MariaDB [Gimnasio]> select usu.IDE_TIPO_IDENTIFICACION,usu.nombre -> t_usuarios usu join t_profesiones pro -> on usu.IDE_PROFESION=pro.IDE_PROFESION -> -> where usu.NUM_IDENTIFICACION='1020481780'; 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 'usu join t_profesiones pro on usu.IDE_PROFESION=pro.IDE_PROFESION where usu.' at line 2 MariaDB [Gimnasio]> select usu.IDE_TIPO_IDENTIFICACION,usu.nombres -> t_usuarios usu join t_profesiones pro -> on usu.IDE_PROFESION=pro.IDE_PROFESION -> -> where usu.NUM_IDENTIFICACION='1020481780'; 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 'usu join t_profesiones pro on usu.IDE_PROFESION=pro.IDE_PROFESION where usu.' at line 2 MariaDB [Gimnasio]> select num_identificacion, ide_profesion from t_usuarios; +--------------------+---------------+ | num_identificacion | ide_profesion | +--------------------+---------------+ | 68387271 | 9 | | 10003838 | 5 | | 28187171 | 10 | | 82828772 | 7 | | 39058589 | 4 | | 10003837 | 6 | | 38278682 | 1 | | 187377289 | 2 | | 1273782909 | 3 | | 10283887 | 8 | +--------------------+---------------+ 10 rows in set (0.00 sec) MariaDB [Gimnasio]> select usu.IDE_TIPO_IDENTIFICACION,usu.nombres -> t_usuarios usu join t_profesiones pro -> on usu.IDE_PROFESION=pro.IDE_PROFESION -> -> where usu.NUM_IDENTIFICACION='82828772'; 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 'usu join t_profesiones pro on usu.IDE_PROFESION=pro.IDE_PROFESION where usu.' at line 2 MariaDB [Gimnasio]> MariaDB [Gimnasio]> select usu.IDE_TIPO_IDENTIFICACION,usu.nombres -> t_usuarios as usu join t_profesiones as pro -> on usu.IDE_PROFESION=pro.IDE_PROFESION -> -> where usu.NUM_IDENTIFICACION='82828772'; 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 'as usu join t_profesiones as pro on usu.IDE_PROFESION=pro.IDE_PROFESION wher' at line 2 MariaDB [Gimnasio]> select * from -> t_usuarios usu join t_profesiones pro -> on usu.IDE_PROFESION=pro.IDE_PROFESION -> -> where usu.NUM_IDENTIFICACION='82828772'; +-------------+--------------------+----------+-----------+-----------+-------------------+----------+-----------+--------------+------------------+----------------+------+-------------------------+----------------------+------------+------------------+---------------+-------------+------------+-------+-------+-------------+---------------+-----------------+------------+---------------+---------------+ | IDE_USUARIO | NUM_IDENTIFICACION | NOMBRES | APELLIDO1 | APELLIDO2 | DIRECCION | TEL_FIJO | TEL_MOVIL | FEC_CREACION | FEC_MODIFICACION | FEC_NACIMIENTO | SEXO | IDE_TIPO_IDENTIFICACION | EMAIL | IDE_ESTADO | IDE_TIPO_USUARIO | IDE_PROFESION | TIPO_CUENTA | NUM_CUENTA | PESO | TALLA | INDICE_MASA | OBSERVACIONES | IDE_PERIODOPAGO | VALOR_PAGO | IDE_PROFESION | DES_PROFESION | +-------------+--------------------+----------+-----------+-----------+-------------------+----------+-----------+--------------+------------------+----------------+------+-------------------------+----------------------+------------+------------------+---------------+-------------+------------+-------+-------+-------------+---------------+-----------------+------------+---------------+---------------+ | 4804230 | 82828772 | Jennifer | Mesa | Martinez | Barrio Sangabriel | 5840570 | 398744140 | 0000-00-00 | 0000-00-00 | 0000-00-00 | 0 | CC | josezapata@gmail.com | 794794 | 111 | 7 | Bancolombi | 2147483647 | 60.00 | 50.00 | 57.00 | Musculo | 1 | 75000 | 7 | Enfermero | +-------------+--------------------+----------+-----------+-----------+-------------------+----------+-----------+--------------+------------------+----------------+------+-------------------------+----------------------+------------+------------------+---------------+-------------+------------+-------+-------+-------------+---------------+-----------------+------------+---------------+---------------+ 1 row in set (0.02 sec) MariaDB [Gimnasio]> select usu.NUM_IDENTIFICACION from -> t_usuarios usu join t_profesiones pro -> on usu.IDE_PROFESION=pro.IDE_PROFESION -> -> where usu.NUM_IDENTIFICACION='82828772'; +--------------------+ | NUM_IDENTIFICACION | +--------------------+ | 82828772 | +--------------------+ 1 row in set (0.00 sec) MariaDB [Gimnasio]> select usu.NUM_IDENTIFICACION, pro.ide_profesion from -> t_usuarios usu join t_profesiones pro -> on usu.IDE_PROFESION=pro.IDE_PROFESION -> -> where usu.NUM_IDENTIFICACION='82828772'; +--------------------+---------------+ | NUM_IDENTIFICACION | ide_profesion | +--------------------+---------------+ | 82828772 | 7 | +--------------------+---------------+ 1 row in set (0.00 sec) MariaDB [Gimnasio]> select * from t_empleados; +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ | IDE_EMPLEADO | NUM_IDENTIFICACION | NOMBRES | APELLIDO1 | APELLIDO2 | DIRECCION | TEL_FIJO | TEL_MOVIL | FEC_INGRESO | IDE_CARGO | ACTIVO | FEC_NACIMIENTO | SEXO | IDE_TIPO_IDENTIFICACION | EMAIL | SALARIO | IDE_PROFESION | DES_PERFIL | +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ | 1 | 1020481780 | Leidy Vanessa | Gutierrez | Hoyos | Barrio la pradera | 5846069 | 3004533498 | 0000-00-00 | 1 | S | 0000-00-00 | F | CC | estebacardona@gmail.com | 1500000 | 2 | Musculo | | 2 | 15510309 | Juliana | Salazar | Fernandez | Barrio rosaleda | 5882104 | 31202122121 | 0000-00-00 | 2 | S | 0000-00-00 | F | CC | dianapatricia@gmail.com | 2500000 | 2 | Bajar de peso | | 3 | 182699765 | Diana | Restrepo | Mendez | Barrio Aragon | 5841998 | 3215414552 | 0000-00-00 | 3 | S | 0000-00-00 | F | CC | jorgezapata@gmail.com | 1000000 | 2 | Piernas | | 4 | 276618199 | William Dario | Casta¤eda | Hernandez | Barrio la pradera | 2791469 | 31748141112 | 0000-00-00 | 4 | S | 0000-00-00 | M | CC | jennyvelasquez@gmail.com | 600000 | 2 | Agdomen | | 5 | 367899090 | Amparo | Giraldo | Pati¤o | Urbanizacion compartir | 2868617 | 325541255 | 0000-00-00 | 1 | S | 0000-00-00 | F | CC | anaposada@gmail.com | 1500000 | 2 | Grasa | | 6 | 673568276 | Juanita | Suarez | Arrieta | Urbanizaci˘n ciudadela prado | 5841497 | 3011857414 | 0000-00-00 | 2 | S | 0000-00-00 | F | CC | indiraortiz@gmail.com | 800000 | 2 | Cardio | | 7 | 182729998 | Walter | Lopez | Pareja | Barrio Sangabriel | 5840570 | 301485120 | 0000-00-00 | 3 | S | 0000-00-00 | M | CC | adrianaquintero@gmail.com | 1500000 | 2 | Aerobicos | | 8 | 103087267 | Stiven | Vergara | Mira | Barrio la pradera | 3767289 | 312485541 | 0000-00-00 | 4 | S | 0000-00-00 | M | CC | edilmamontoya@gmail.com | 2500000 | 2 | Grasa | +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ 8 rows in set (0.00 sec) MariaDB [Gimnasio]> MariaDB [Gimnasio]> select usu.NUM_IDENTIFICACION, pro.ide_profesion, em.nombres from -> t_usuarios usu join t_profesiones pro -> on usu.IDE_PROFESION=pro.IDE_PROFESION -> join T_EMPLEADOS em on usu.IDE_PROFESION=em.IDE_PROFESION -> -> where usu.NUM_IDENTIFICACION='82828772'; Empty set (0.02 sec) MariaDB [Gimnasio]> MariaDB [Gimnasio]> select usu.NUM_IDENTIFICACION, pro.ide_profesion, em.nombres from -> t_usuarios usu join t_profesiones pro -> on usu.IDE_PROFESION=pro.IDE_PROFESION -> join T_EMPLEADOS em on usu.IDE_PROFESION=em.IDE_PROFESION -> -> where usu.NUM_IDENTIFICACION='82828772'; Empty set (0.00 sec) MariaDB [Gimnasio]> select usu.NUM_IDENTIFICACION, pro.ide_profesion, em.nombres from -> t_usuarios usu join t_profesiones pro -> on usu.IDE_PROFESION=pro.IDE_PROFESION -> join T_EMPLEADOS em on usu.IDE_PROFESION=em.IDE_PROFESION -> -> where usu.NUM_IDENTIFICACION='182699765'; Empty set (0.00 sec) MariaDB [Gimnasio]> select * from -> t_usuarios usu join t_profesiones pro -> on usu.IDE_PROFESION=pro.IDE_PROFESION -> -> where usu.NUM_IDENTIFICACION='82828772'; +-------------+--------------------+----------+-----------+-----------+-------------------+----------+-----------+--------------+------------------+----------------+------+-------------------------+----------------------+------------+------------------+---------------+-------------+------------+-------+-------+-------------+---------------+-----------------+------------+---------------+---------------+ | IDE_USUARIO | NUM_IDENTIFICACION | NOMBRES | APELLIDO1 | APELLIDO2 | DIRECCION | TEL_FIJO | TEL_MOVIL | FEC_CREACION | FEC_MODIFICACION | FEC_NACIMIENTO | SEXO | IDE_TIPO_IDENTIFICACION | EMAIL | IDE_ESTADO | IDE_TIPO_USUARIO | IDE_PROFESION | TIPO_CUENTA | NUM_CUENTA | PESO | TALLA | INDICE_MASA | OBSERVACIONES | IDE_PERIODOPAGO | VALOR_PAGO | IDE_PROFESION | DES_PROFESION | +-------------+--------------------+----------+-----------+-----------+-------------------+----------+-----------+--------------+------------------+----------------+------+-------------------------+----------------------+------------+------------------+---------------+-------------+------------+-------+-------+-------------+---------------+-----------------+------------+---------------+---------------+ | 4804230 | 82828772 | Jennifer | Mesa | Martinez | Barrio Sangabriel | 5840570 | 398744140 | 0000-00-00 | 0000-00-00 | 0000-00-00 | 0 | CC | josezapata@gmail.com | 794794 | 111 | 7 | Bancolombi | 2147483647 | 60.00 | 50.00 | 57.00 | Musculo | 1 | 75000 | 7 | Enfermero | +-------------+--------------------+----------+-----------+-----------+-------------------+----------+-----------+--------------+------------------+----------------+------+-------------------------+----------------------+------------+------------------+---------------+-------------+------------+-------+-------+-------------+---------------+-----------------+------------+---------------+---------------+ 1 row in set (0.00 sec) MariaDB [Gimnasio]> select NUM_IDENTIFICACION from empleados -> union all -> select NUM_IDENTIFICACION from usuarios; ERROR 1146 (42S02): Table 'gimnasio.empleados' doesn't exist MariaDB [Gimnasio]> select NUM_IDENTIFICACION from t_empleados -> union all -> select NUM_IDENTIFICACION from t_usuarios; +--------------------+ | NUM_IDENTIFICACION | +--------------------+ | 1020481780 | | 15510309 | | 182699765 | | 276618199 | | 367899090 | | 673568276 | | 182729998 | | 103087267 | | 68387271 | | 10003838 | | 28187171 | | 82828772 | | 39058589 | | 10003837 | | 38278682 | | 187377289 | | 1273782909 | | 10283887 | +--------------------+ 18 rows in set (0.01 sec) MariaDB [Gimnasio]> MariaDB [Gimnasio]> MariaDB [Gimnasio]> select NUM_IDENTIFICACION, FEC_NACIMIENTO from t_empleados -> union all -> select NUM_IDENTIFICACION, FEC_NACIMIENTO from t_usuarios; +--------------------+----------------+ | NUM_IDENTIFICACION | FEC_NACIMIENTO | +--------------------+----------------+ | 1020481780 | 0000-00-00 | | 15510309 | 0000-00-00 | | 182699765 | 0000-00-00 | | 276618199 | 0000-00-00 | | 367899090 | 0000-00-00 | | 673568276 | 0000-00-00 | | 182729998 | 0000-00-00 | | 103087267 | 0000-00-00 | | 68387271 | 0000-00-00 | | 10003838 | 0000-00-00 | | 28187171 | 0000-00-00 | | 82828772 | 0000-00-00 | | 39058589 | 0000-00-00 | | 10003837 | 0000-00-00 | | 38278682 | 0000-00-00 | | 187377289 | 0000-00-00 | | 1273782909 | 0000-00-00 | | 10283887 | 0000-00-00 | +--------------------+----------------+ 18 rows in set (0.02 sec) MariaDB [Gimnasio]> select NUM_IDENTIFICACION, FEC_NACIMIENTO from t_empleados; +--------------------+----------------+ | NUM_IDENTIFICACION | FEC_NACIMIENTO | +--------------------+----------------+ | 1020481780 | 0000-00-00 | | 15510309 | 0000-00-00 | | 182699765 | 0000-00-00 | | 276618199 | 0000-00-00 | | 367899090 | 0000-00-00 | | 673568276 | 0000-00-00 | | 182729998 | 0000-00-00 | | 103087267 | 0000-00-00 | +--------------------+----------------+ 8 rows in set (0.00 sec) MariaDB [Gimnasio]> select * from t_empleados; +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ | IDE_EMPLEADO | NUM_IDENTIFICACION | NOMBRES | APELLIDO1 | APELLIDO2 | DIRECCION | TEL_FIJO | TEL_MOVIL | FEC_INGRESO | IDE_CARGO | ACTIVO | FEC_NACIMIENTO | SEXO | IDE_TIPO_IDENTIFICACION | EMAIL | SALARIO | IDE_PROFESION | DES_PERFIL | +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ | 1 | 1020481780 | Leidy Vanessa | Gutierrez | Hoyos | Barrio la pradera | 5846069 | 3004533498 | 0000-00-00 | 1 | S | 0000-00-00 | F | CC | estebacardona@gmail.com | 1500000 | 2 | Musculo | | 2 | 15510309 | Juliana | Salazar | Fernandez | Barrio rosaleda | 5882104 | 31202122121 | 0000-00-00 | 2 | S | 0000-00-00 | F | CC | dianapatricia@gmail.com | 2500000 | 2 | Bajar de peso | | 3 | 182699765 | Diana | Restrepo | Mendez | Barrio Aragon | 5841998 | 3215414552 | 0000-00-00 | 3 | S | 0000-00-00 | F | CC | jorgezapata@gmail.com | 1000000 | 2 | Piernas | | 4 | 276618199 | William Dario | Casta¤eda | Hernandez | Barrio la pradera | 2791469 | 31748141112 | 0000-00-00 | 4 | S | 0000-00-00 | M | CC | jennyvelasquez@gmail.com | 600000 | 2 | Agdomen | | 5 | 367899090 | Amparo | Giraldo | Pati¤o | Urbanizacion compartir | 2868617 | 325541255 | 0000-00-00 | 1 | S | 0000-00-00 | F | CC | anaposada@gmail.com | 1500000 | 2 | Grasa | | 6 | 673568276 | Juanita | Suarez | Arrieta | Urbanizaci˘n ciudadela prado | 5841497 | 3011857414 | 0000-00-00 | 2 | S | 0000-00-00 | F | CC | indiraortiz@gmail.com | 800000 | 2 | Cardio | | 7 | 182729998 | Walter | Lopez | Pareja | Barrio Sangabriel | 5840570 | 301485120 | 0000-00-00 | 3 | S | 0000-00-00 | M | CC | adrianaquintero@gmail.com | 1500000 | 2 | Aerobicos | | 8 | 103087267 | Stiven | Vergara | Mira | Barrio la pradera | 3767289 | 312485541 | 0000-00-00 | 4 | S | 0000-00-00 | M | CC | edilmamontoya@gmail.com | 2500000 | 2 | Grasa | +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ 8 rows in set (0.00 sec) MariaDB [Gimnasio]> update t_empleados set FEC_NACIMIENTO=to_date(2018-09-01) where NUM_IDENTIFICACION=1020481780; ERROR 1305 (42000): FUNCTION gimnasio.to_date does not exist MariaDB [Gimnasio]> update t_empleados set FEC_NACIMIENTO='2018-09-01' where NUM_IDENTIFICACION=1020481780; Query OK, 1 row affected (0.15 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [Gimnasio]> select * from t_empleados; +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ | IDE_EMPLEADO | NUM_IDENTIFICACION | NOMBRES | APELLIDO1 | APELLIDO2 | DIRECCION | TEL_FIJO | TEL_MOVIL | FEC_INGRESO | IDE_CARGO | ACTIVO | FEC_NACIMIENTO | SEXO | IDE_TIPO_IDENTIFICACION | EMAIL | SALARIO | IDE_PROFESION | DES_PERFIL | +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ | 1 | 1020481780 | Leidy Vanessa | Gutierrez | Hoyos | Barrio la pradera | 5846069 | 3004533498 | 0000-00-00 | 1 | S | 2018-09-01 | F | CC | estebacardona@gmail.com | 1500000 | 2 | Musculo | | 2 | 15510309 | Juliana | Salazar | Fernandez | Barrio rosaleda | 5882104 | 31202122121 | 0000-00-00 | 2 | S | 0000-00-00 | F | CC | dianapatricia@gmail.com | 2500000 | 2 | Bajar de peso | | 3 | 182699765 | Diana | Restrepo | Mendez | Barrio Aragon | 5841998 | 3215414552 | 0000-00-00 | 3 | S | 0000-00-00 | F | CC | jorgezapata@gmail.com | 1000000 | 2 | Piernas | | 4 | 276618199 | William Dario | Casta¤eda | Hernandez | Barrio la pradera | 2791469 | 31748141112 | 0000-00-00 | 4 | S | 0000-00-00 | M | CC | jennyvelasquez@gmail.com | 600000 | 2 | Agdomen | | 5 | 367899090 | Amparo | Giraldo | Pati¤o | Urbanizacion compartir | 2868617 | 325541255 | 0000-00-00 | 1 | S | 0000-00-00 | F | CC | anaposada@gmail.com | 1500000 | 2 | Grasa | | 6 | 673568276 | Juanita | Suarez | Arrieta | Urbanizaci˘n ciudadela prado | 5841497 | 3011857414 | 0000-00-00 | 2 | S | 0000-00-00 | F | CC | indiraortiz@gmail.com | 800000 | 2 | Cardio | | 7 | 182729998 | Walter | Lopez | Pareja | Barrio Sangabriel | 5840570 | 301485120 | 0000-00-00 | 3 | S | 0000-00-00 | M | CC | adrianaquintero@gmail.com | 1500000 | 2 | Aerobicos | | 8 | 103087267 | Stiven | Vergara | Mira | Barrio la pradera | 3767289 | 312485541 | 0000-00-00 | 4 | S | 0000-00-00 | M | CC | edilmamontoya@gmail.com | 2500000 | 2 | Grasa | +--------------+--------------------+---------------+-----------+-----------+-------------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ 8 rows in set (0.00 sec) MariaDB [Gimnasio]> select u.NUM_IDENTIFICACION,u.NOMBRES,u.IDE_TIPO_USUARIO, tp.DES_TIPO_USUARIO -> -> from t_usuarios u, t_TIPO_USUARIO ; ERROR 1054 (42S22): Unknown column 'tp.DES_TIPO_USUARIO' in 'field list' MariaDB [Gimnasio]> elect u.NUM_IDENTIFICACION,u.NOMBRES,u.IDE_TIPO_USUARIO, tp.DES_TIPO_USUARIO -> -> from t_usuarios u, t_T -> ; 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 'elect u.NUM_IDENTIFICACION,u.NOMBRES,u.IDE_TIPO_USUARIO, tp.DES_TIPO_USUARIO f' at line 1 MariaDB [Gimnasio]> select u.NUM_IDENTIFICACION,u.NOMBRES,u.IDE_TIPO_USUARIO, tp.DES_TIPO_USUARIO -> -> from t_usuarios u, t_TIPO_USUARIO tp; +--------------------+--------------+------------------+------------------+ | NUM_IDENTIFICACION | NOMBRES | IDE_TIPO_USUARIO | DES_TIPO_USUARIO | +--------------------+--------------+------------------+------------------+ | 68387271 | Vanessa | 220 | Bloqueado | | 68387271 | Vanessa | 220 | Inactivo | | 68387271 | Vanessa | 220 | Activo | | 68387271 | Vanessa | 220 | No Existe | | 10003838 | Javier | 220 | Bloqueado | | 10003838 | Javier | 220 | Inactivo | | 10003838 | Javier | 220 | Activo | | 10003838 | Javier | 220 | No Existe | | 28187171 | Sebastian | 220 | Bloqueado | | 28187171 | Sebastian | 220 | Inactivo | | 28187171 | Sebastian | 220 | Activo | | 28187171 | Sebastian | 220 | No Existe | | 82828772 | Jennifer | 111 | Bloqueado | | 82828772 | Jennifer | 111 | Inactivo | | 82828772 | Jennifer | 111 | Activo | | 82828772 | Jennifer | 111 | No Existe | | 39058589 | Alexander | 220 | Bloqueado | | 39058589 | Alexander | 220 | Inactivo | | 39058589 | Alexander | 220 | Activo | | 39058589 | Alexander | 220 | No Existe | | 10003837 | Henry | 220 | Bloqueado | | 10003837 | Henry | 220 | Inactivo | | 10003837 | Henry | 220 | Activo | | 10003837 | Henry | 220 | No Existe | | 38278682 | Oscar | 220 | Bloqueado | | 38278682 | Oscar | 220 | Inactivo | | 38278682 | Oscar | 220 | Activo | | 38278682 | Oscar | 220 | No Existe | | 187377289 | Jaime | 210 | Bloqueado | | 187377289 | Jaime | 210 | Inactivo | | 187377289 | Jaime | 210 | Activo | | 187377289 | Jaime | 210 | No Existe | | 1273782909 | Ramon Andres | 111 | Bloqueado | | 1273782909 | Ramon Andres | 111 | Inactivo | | 1273782909 | Ramon Andres | 111 | Activo | | 1273782909 | Ramon Andres | 111 | No Existe | | 10283887 | Cesar | 220 | Bloqueado | | 10283887 | Cesar | 220 | Inactivo | | 10283887 | Cesar | 220 | Activo | | 10283887 | Cesar | 220 | No Existe | +--------------------+--------------+------------------+------------------+ 40 rows in set (0.00 sec) MariaDB [Gimnasio]> select u.NUM_IDENTIFICACION,u.NOMBRES,u.IDE_TIPO_USUARIO, tp.DES_TIPO_USUARIO -> -> from t_usuarios u, t_TIPO_USUARIO tp where u.IDE_TIPO_USUARIO=tp.IDE_TIPO_USUARIO; +--------------------+--------------+------------------+------------------+ | NUM_IDENTIFICACION | NOMBRES | IDE_TIPO_USUARIO | DES_TIPO_USUARIO | +--------------------+--------------+------------------+------------------+ | 68387271 | Vanessa | 220 | Activo | | 10003838 | Javier | 220 | Activo | | 28187171 | Sebastian | 220 | Activo | | 82828772 | Jennifer | 111 | Bloqueado | | 39058589 | Alexander | 220 | Activo | | 10003837 | Henry | 220 | Activo | | 38278682 | Oscar | 220 | Activo | | 187377289 | Jaime | 210 | Inactivo | | 1273782909 | Ramon Andres | 111 | Bloqueado | | 10283887 | Cesar | 220 | Activo | +--------------------+--------------+------------------+------------------+ 10 rows in set (0.00 sec) MariaDB [Gimnasio]> select u.NUM_IDENTIFICACION,u.NOMBRES,u.IDE_TIPO_USUARIO, tp.DES_TIPO_USUARIO -> -> from t_usuarios u, t_TIPO_USUARIO tp where u.IDE_TIPO_USUARIO=tp.IDE_TIPO_USUARIO and tp.IDE_TIPO_USUARIO=220; +--------------------+------------+------------------+------------------+ | NUM_IDENTIFICACION | NOMBRES | IDE_TIPO_USUARIO | DES_TIPO_USUARIO | +--------------------+------------+------------------+------------------+ | 68387271 | Vanessa | 220 | Activo | | 10003838 | Javier | 220 | Activo | | 28187171 | Sebastian | 220 | Activo | | 39058589 | Alexander | 220 | Activo | | 10003837 | Henry | 220 | Activo | | 38278682 | Oscar | 220 | Activo | | 10283887 | Cesar | 220 | Activo | +--------------------+------------+------------------+------------------+ 7 rows in set (0.00 sec) MariaDB [Gimnasio]> MariaDB [Gimnasio]> select * from t_empleados where NUM_IDENTIFICACION like '1%'; +--------------+--------------------+---------------+-----------+-----------+-------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ | IDE_EMPLEADO | NUM_IDENTIFICACION | NOMBRES | APELLIDO1 | APELLIDO2 | DIRECCION | TEL_FIJO | TEL_MOVIL | FEC_INGRESO | IDE_CARGO | ACTIVO | FEC_NACIMIENTO | SEXO | IDE_TIPO_IDENTIFICACION | EMAIL | SALARIO | IDE_PROFESION | DES_PERFIL | +--------------+--------------------+---------------+-----------+-----------+-------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ | 1 | 1020481780 | Leidy Vanessa | Gutierrez | Hoyos | Barrio la pradera | 5846069 | 3004533498 | 0000-00-00 | 1 | S | 2018-09-01 | F | CC | estebacardona@gmail.com | 1500000 | 2 | Musculo | | 2 | 15510309 | Juliana | Salazar | Fernandez | Barrio rosaleda | 5882104 | 31202122121 | 0000-00-00 | 2 | S | 0000-00-00 | F | CC | dianapatricia@gmail.com | 2500000 | 2 | Bajar de peso | | 3 | 182699765 | Diana | Restrepo | Mendez | Barrio Aragon | 5841998 | 3215414552 | 0000-00-00 | 3 | S | 0000-00-00 | F | CC | jorgezapata@gmail.com | 1000000 | 2 | Piernas | | 7 | 182729998 | Walter | Lopez | Pareja | Barrio Sangabriel | 5840570 | 301485120 | 0000-00-00 | 3 | S | 0000-00-00 | M | CC | adrianaquintero@gmail.com | 1500000 | 2 | Aerobicos | | 8 | 103087267 | Stiven | Vergara | Mira | Barrio la pradera | 3767289 | 312485541 | 0000-00-00 | 4 | S | 0000-00-00 | M | CC | edilmamontoya@gmail.com | 2500000 | 2 | Grasa | +--------------+--------------------+---------------+-----------+-----------+-------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ 5 rows in set (0.00 sec) MariaDB [Gimnasio]> select * from t_empleados where SALARIO >=1000000; +--------------+--------------------+---------------+-----------+-----------+------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ | IDE_EMPLEADO | NUM_IDENTIFICACION | NOMBRES | APELLIDO1 | APELLIDO2 | DIRECCION | TEL_FIJO | TEL_MOVIL | FEC_INGRESO | IDE_CARGO | ACTIVO | FEC_NACIMIENTO | SEXO | IDE_TIPO_IDENTIFICACION | EMAIL | SALARIO | IDE_PROFESION | DES_PERFIL | +--------------+--------------------+---------------+-----------+-----------+------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ | 1 | 1020481780 | Leidy Vanessa | Gutierrez | Hoyos | Barrio la pradera | 5846069 | 3004533498 | 0000-00-00 | 1 | S | 2018-09-01 | F | CC | estebacardona@gmail.com | 1500000 | 2 | Musculo | | 2 | 15510309 | Juliana | Salazar | Fernandez | Barrio rosaleda | 5882104 | 31202122121 | 0000-00-00 | 2 | S | 0000-00-00 | F | CC | dianapatricia@gmail.com | 2500000 | 2 | Bajar de peso | | 3 | 182699765 | Diana | Restrepo | Mendez | Barrio Aragon | 5841998 | 3215414552 | 0000-00-00 | 3 | S | 0000-00-00 | F | CC | jorgezapata@gmail.com | 1000000 | 2 | Piernas | | 5 | 367899090 | Amparo | Giraldo | Pati¤o | Urbanizacion compartir | 2868617 | 325541255 | 0000-00-00 | 1 | S | 0000-00-00 | F | CC | anaposada@gmail.com | 1500000 | 2 | Grasa | | 7 | 182729998 | Walter | Lopez | Pareja | Barrio Sangabriel | 5840570 | 301485120 | 0000-00-00 | 3 | S | 0000-00-00 | M | CC | adrianaquintero@gmail.com | 1500000 | 2 | Aerobicos | | 8 | 103087267 | Stiven | Vergara | Mira | Barrio la pradera | 3767289 | 312485541 | 0000-00-00 | 4 | S | 0000-00-00 | M | CC | edilmamontoya@gmail.com | 2500000 | 2 | Grasa | +--------------+--------------------+---------------+-----------+-----------+------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+---------------------------+---------+---------------+---------------+ 6 rows in set (0.01 sec) MariaDB [Gimnasio]> select * from t_empleados where SALARIO >=1000000 and sexo like 'F%'; +--------------+--------------------+---------------+-----------+-----------+------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+-------------------------+---------+---------------+---------------+ | IDE_EMPLEADO | NUM_IDENTIFICACION | NOMBRES | APELLIDO1 | APELLIDO2 | DIRECCION | TEL_FIJO | TEL_MOVIL | FEC_INGRESO | IDE_CARGO | ACTIVO | FEC_NACIMIENTO | SEXO | IDE_TIPO_IDENTIFICACION | EMAIL | SALARIO | IDE_PROFESION | DES_PERFIL | +--------------+--------------------+---------------+-----------+-----------+------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+-------------------------+---------+---------------+---------------+ | 1 | 1020481780 | Leidy Vanessa | Gutierrez | Hoyos | Barrio la pradera | 5846069 | 3004533498 | 0000-00-00 | 1 | S | 2018-09-01 | F | CC | estebacardona@gmail.com | 1500000 | 2 | Musculo | | 2 | 15510309 | Juliana | Salazar | Fernandez | Barrio rosaleda | 5882104 | 31202122121 | 0000-00-00 | 2 | S | 0000-00-00 | F | CC | dianapatricia@gmail.com | 2500000 | 2 | Bajar de peso | | 3 | 182699765 | Diana | Restrepo | Mendez | Barrio Aragon | 5841998 | 3215414552 | 0000-00-00 | 3 | S | 0000-00-00 | F | CC | jorgezapata@gmail.com | 1000000 | 2 | Piernas | | 5 | 367899090 | Amparo | Giraldo | Pati¤o | Urbanizacion compartir | 2868617 | 325541255 | 0000-00-00 | 1 | S | 0000-00-00 | F | CC | anaposada@gmail.com | 1500000 | 2 | Grasa | +--------------+--------------------+---------------+-----------+-----------+------------------------+----------+-------------+-------------+-----------+--------+----------------+------+-------------------------+-------------------------+---------+---------------+---------------+ 4 rows in set (0.00 sec) MariaDB [Gimnasio]> MariaDB [Gimnasio]> select nombre,apellido1,apellido2,salario from t_empleados where SALARIO >=1000000 and sexo like 'F%'; ERROR 1054 (42S22): Unknown column 'nombre' in 'field list' MariaDB [Gimnasio]> select nombres,apellido1,apellido2,salario from t_empleados where SALARIO >=1000000 and sexo like 'F%'; +---------------+-----------+-----------+---------+ | nombres | apellido1 | apellido2 | salario | +---------------+-----------+-----------+---------+ | Leidy Vanessa | Gutierrez | Hoyos | 1500000 | | Juliana | Salazar | Fernandez | 2500000 | | Diana | Restrepo | Mendez | 1000000 | | Amparo | Giraldo | Pati¤o | 1500000 | +---------------+-----------+-----------+---------+ 4 rows in set (0.00 sec) MariaDB [Gimnasio]> select nombres,apellido1 primer_apellido,apellido2 segundo_apellido,salario from t_empleados where SALARIO >=1000000 and sexo like 'F%'; +---------------+-----------------+------------------+---------+ | nombres | primer_apellido | segundo_apellido | salario | +---------------+-----------------+------------------+---------+ | Leidy Vanessa | Gutierrez | Hoyos | 1500000 | | Juliana | Salazar | Fernandez | 2500000 | | Diana | Restrepo | Mendez | 1000000 | | Amparo | Giraldo | Pati¤o | 1500000 | +---------------+-----------------+------------------+---------+ 4 rows in set (0.00 sec) MariaDB [Gimnasio]> select e.nombres,e.apellido1 primer_apellido,e.apellido2 segundo_apellido,e.salario,p.DES_PROFESION from t_empleados e, t_profesiones p where e.DES_PROFESION=p.DES_PROFESION; ERROR 1054 (42S22): Unknown column 'e.DES_PROFESION' in 'where clause' MariaDB [Gimnasio]> clear MariaDB [Gimnasio]> cls ->