Hello, good morning and I look forward to your help. I need to get out of the table
and the table user:
all those restaurants that do not belong to a user in this case is 3 (empty restaurant name), because as you can see in the user table the id_restaurante of each user is either 1 or 2.
I've been doing this for a while now, I've done this but he does not take it out:
select r.id, r.nombre, r.direccion, r.ciudad, r.provincia, r.cp, r.cif, r.imagen_url, r.horario from restaurante r inner join usuario u on u.id_restaurante = r.id where u.id_restaurante != r.id group by r.id