12 lines
446 B
SQL
12 lines
446 B
SQL
|
|
select UNIQUE a.tipo,a.num_oc,a.fech_oc,b.nom_sp,a.c_flete,a.otros_g,
|
|
SUM(d.cantidad * d.precio)
|
|
FROM cotb00014 a,cotb00001 b,cotb00015 d
|
|
WHERE b.cod_sp = a.cod_sp AND b.cod_sp_sec = a.cod_sp_sec AND
|
|
a.num_oc = d.num_oc AND a.tipo = d.tipo AND
|
|
a.fech_oc between "010197" AND "120897" AND
|
|
a.tipo = a.tipo AND a.cod_sp_sec = a.cod_sp_sec AND
|
|
a.status_t is null
|
|
GROUP BY 1,2,3,4,5,6
|
|
ORDER BY 1,2
|