Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Saber con que forma de pago se pagó determinado folio en determinada área de venta. Filtro de fecha.
- SELECT cheques.folio, chequespagos.idformadepago, cheques.observaciones
- FROM cheques
- INNER JOIN chequespagos ON cheques.folio = chequespagos.folio
- WHERE cheques.idarearestaurant= 2 AND cheques.observaciones <> '' AND idformadepago IN ('EF','MC')
- 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