4
I’m having a problem at a SELECT:
SELECT * FROM documento WHERE idAdministrador = '1' AND modulo = 'funcionario' OR modulo = 'atestado'
I need you, if module is working or attested, to do the correct search... However, it does not search for those who have idAdministrator = '1', the query base is the module only... Returns independent of idAdministrator being 1 or not.
How do I make a SELECT to search for the ID first, and if it’s working module or attested, list it correctly?
idAdministrador = '1' AND (modulo = 'funcionario' OR modulo = 'atestado')
?– DontVoteMeDown
Post as answer. It worked, thank you too!
– Sr. André Baill