How to make a query with unrelated data MySQL

Question

How to make a query with unrelated data MySQL

Navigation

#1 by (1 votes)

-1

How can I make this query in mysql?

'SELECT * FROM tblEmpleados e LEFT JOIN tblUsuarios u on u.usuarios_nombres,' 'u.usuarios_apellido_paterno  LIKE' concat('%',e.empleados_nombres,'%','%',e.empleados_apellido_paterno,'%')

I do not have a field ID that relates them, it occurred to me to do a left join with a like by names

tabla empleados
----------------
nombre
juanito elbrayan

tabla usuarios
----------------
nombreUsuario
juanito elbrayan

but I get NULL in the fields on the right.

mysql

asked by Carlos Enrique Gil Gil 29.06.2018 в 00:16

source

1 answer

Integrate CSS in HTML Why do I get an error in this Java abstract class? [closed]

score 1 · Answer 1

Here I leave the answer do not get angry

SELECT concat(u.usuarios_nombres,' ',u.usuarios_apellido_paterno,' ',u.usuarios_apellido_materno) 
AS nombre,u.usuarios_usuario,e.empleados_puesto,e.departamento 
FROM tblEmpleados e 
INNER JOIN tblUsuarios u ON concat(u.usuarios_nombres,' ',u.usuarios_apellido_paterno,' ',u.usuarios_apellido_materno) 
LIKE concat('%',e.empleados_nombres,'%','%',e.empleados_apellido_paterno,'%','%',e.empleados_apellido_materno,'%')

thanks for your help