404

D7net

:/ var / www / html / crsys /

Filename : ler orcamentos e suas tabelas.sql

back

use dados_mont_blanc;
select * from tblorcamento where n_orcamento = 57304 and n_revisao = 0
select * from tblobra where n_obra = 7562 order by data desc limit 10
select * from tblagendadados where n_obra = 7562;
select * from tblpedido where n_orcamento = 57304;
select * from tblpedido where n_cadastro > 0 order by data desc limit 10;
select * from tblcadastro  where n_cadastro = 451;
select * from tblcadastro  where status = 'CANCELADO' order by data desc limit 10;
select * from tblpedido where n_cadastro = 1997;
select status, count(*) from tblcadastro group by status