Advertisement
EmilianoRoldanR

Saber con que forma de pago se pago determinado folio

Aug 28th, 2019
385
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.44 KB | None | 0 0
  1. --Saber con que forma de pago se pagó determinado folio en determinada área de venta. Filtro de fecha.
  2.  
  3. SELECT cheques.folio, chequespagos.idformadepago, cheques.observaciones
  4. FROM cheques
  5. INNER JOIN chequespagos ON cheques.folio = chequespagos.folio
  6. WHERE cheques.idarearestaurant= 2 AND cheques.observaciones <> '' AND idformadepago IN ('EF','MC')
  7. AND cheques.cierre >= '1/1/2019 00:00:00 am' AND cheques.cierre <= '1/5/2019 00:00:00 am'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement