In Mysql I have a login table, which shows who logged in to the system:
id | cod_user
After the website is ready and working, the client has passed me a list of cod_usuario that CAN log into the system, so I created a table can and did this verification every time someone logs in, who is not can can not log in without problems.
Now the customer wants to know who has already logged on to the system and who was not in the table can , how to do this?
It would be something like:
SELECT cod FROM login
LEFT JOIN pode ON pode.cod_usuario = login.cod_usuario
But I do not know how to get the ones that are in the login table and are NOT in the can table