search

VicenteCool / RetailOne

0 stars 0 forks source link

DO con CA y parace un DE basada en DO #41

Closed VicenteCool closed 4 years ago

VicenteCool commented 4 years ago

imagen

VicenteCool commented 4 years ago

select t0.Name, t0.U_SO1_FECHA, t0.U_SO1_VERSIONR1, t0.U_SO1_FOLIODESTINO, U_SO1_CODIGOFP, t2.Name, t2.U_SO1_FECHA, t2.U_SO1_VERSIONR1 from "@SO1_01VENTA" t0 left join "@SO1_01VENTACOBRO" t1 on t0.U_SO1_FOLIODESTINO=t1.U_SO1_FOLIO left join "@SO1_01DEVOLUCION" t2 on t2.U_SO1_FOLIOCAJA=t0.Name where t0.U_SO1_TIPO='DO' and U_SO1_FOLIODESTINO is not null and t0.U_SO1_FECHA>='20190301'

imagen