Hi.
I was testing a select before to create a view but it did not work. I need to select the name of three companies and restrict a city. I can select the 3 companies, but when I go restrict the city no error occurs, but the select returns me the same companies but in the entire state. If I select one company and a city, everything is fine,
My select is this.
select municipio, entidade from empresas
where entidade like '%EMPRESA01%' or entidade like '%EMPRESA02%' or entidade like 'EMPRESA03%' and municipio = 'Cidade01'
Thank you.