[redes] comandinho sql
- From: Gustavo O Ph <gustavoph80@xxxxxxxxx>
- To: redes@xxxxxxxxxxxxx
- Date: Thu, 10 Oct 2013 11:42:43 -0300
--select * from gerfornecedor gfor where gfor.cod_fornecedor < 100
--select * from vtcentro_custo cli where cli.cod_cc > 50
select mat.cod_material,
mat.nome_material,
mat.valor_estoque,
mat.preco_venda,
mat.material_ativo
from almmaterial mat
where (mat.cod_material > 10
and mat.cod_material < 100)
and mat.codigo_barra is null
order by mat.nome_material asc
Other related posts:
- » [redes] comandinho sql - Gustavo O Ph
