|
select
`regoper_part`.`regoper_part_id` AS regoper_part_id`,
`regoper_part`.`regoper_id` AS `regoper_id`,
`regoper_part`.`proveedor_id` AS `proveedor_id`,
`proveedor`.`prv_rfc` AS `PRV_RFC`,
`proveedor`.`prv_nombre` AS `PRV_NOMBRE`,
`regoper_part`.`rpp_numpartida` AS `RPP_NUMPARTIDA`,
`regoper_part`.`rpp_numpoliza` AS `RPP_NUMPOLIZA`,
`regoper_part`.`rpp_numfactura` AS `RPP_NUMFACTURA`,
`regoper_part`.`rpp_mesfactura` AS `RPP_MESFACTURA`,
`regoper_part`.`rpp_iva` AS `RPP_IVA`,
`regoper_part`.`rpp_importe` AS `RPP_IMPORTE`,
`regoper_part`.`rpp_pendientespoliza` AS `RPP_PENDIENTESPOLIZA`
from (`regoper_part` left join `proveedor` on((`regoper_part`.`proveedor_id` = `proveedor`.`proveedor_id`)))
|