01-28-2019, 01:34 AM
SELECT vtiger_cobropago.cyp_no, vtiger_cobropago.parent_id, vtiger_crmentity.smownerid, vtiger_cobropago.paymentmode, vtiger_cobropagocf.cf_871, vtiger_cobropagocf.cf_977, vtiger_cobropago.amount, vtiger_cobropago.cobropagoid FROM vtiger_cobropago INNER JOIN vtiger_crmentity ON vtiger_cobropago.cobropagoid = vtiger_crmentity.crmid LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id LEFT JOIN vtiger_groups ON vtiger_crmentity.smownerid = vtiger_groups.groupid INNER JOIN vtiger_cobropagocf ON vtiger_cobropago.cobropagoid = vtiger_cobropagocf.cobropagoid WHERE vtiger_crmentity.deleted=0 AND ( (( vtiger_cobropago.paid <> '1') )) AND vtiger_cobropago.cobropagoid > 0
Strange ... exactly a test for "Nota Promissória" is omitted in sql command ...
Strange ... exactly a test for "Nota Promissória" is omitted in sql command ...
Ranieri
eCRM Web
eCRM Web