Hello! I have the table OPERACAO where I have 3 columns: Codoper, description, nautureza. I have to design the description and nature of all input operations. Then sort by the operation code. Operation code 1, 3 and 6 are my input operations. Code 2, 4 and 5 are output. I'm locked in where ...
Select operacao.descricao, operacao.natureza, operacao.codoper
From operacao
Where ___________________
Order by operacao.codoper
If anyone can give a tip or help, I'm grateful.