BlueGrey
calm
Elegant
Català-Valencià - Catalan
中文 - Chinese (Simplified)
中文 - Chinese (Traditional)
Česky - Czech
Dansk - Danish
Nederlands - Dutch
English - English
Suomi - Finnish
Français - French
Deutsch - German
עברית - Hebrew
हिंदी - Hindi
Magyar - Hungarian
Bahasa Indonesia - Indonesian
Italiano - Italian
日本語 - Japanese
한국어 - Korean
Македонски - Macedonian
मराठी - Marathi
Norsk - Norwegian
Polski - Polish
Português - Portuguese
Português - Portuguese (Brazil)
Русский - Russian
Slovenčina - Slovak
Slovenščina - Slovenian
Español - Spanish
Svenska - Swedish
Türkçe - Turkish
Українська - Ukrainian
Oëzbekcha - Uzbek
Subversion Repositories
Integrator Subversion
(root)
/
DOCUMENTOS E ANALISE
/
SQL - RELATÓRIOS
/
sql - estoque total.sql
- Rev 1
Rev
Blame
|
Last modification
|
View Log
|
Download
|
RSS feed
SELECT
SUM
(
p
.
qtd_estoque_loja
)
+
SUM
(
p
.
qtd_estoque_quiosque
)
FROM
sc_sec
.
sec_produto p
WHERE
(
p
.
qtd_estoque_loja
+
p
.
qtd_estoque_quiosque
)
>=
0
AND
p
.
cod_produto
<>
'000000'
;