SELECT `id`, `vente`, `montant`, `porteur`, `encaissement`, `dateEncaissement`, `ville`, `client` AS `partenaire`, `photo`, 'vente' AS `type`, `id_caisse`
FROM `vente_reglement`
WHERE `mode` = 'Espece'
UNION
SELECT `id`, `achat`, `montant`, `porteur`, `encaissement`, `dateEncaissement`, `ville`, `fournisseur` AS `partenaire`, `photo`, 'achat' AS `type`, `id_caisse`
FROM `achat_reglement`
WHERE `mode` = 'Espece'
UNION
SELECT `id`, `nom`, `montant`, `porteur`, `encaissement`, `dateEncaissement`, `ville`, `beneficiaire` AS `partenaire`, `img` AS `photo`, 'encaissement', `id_caisse`
FROM `encaissement`
WHERE 1