1 2 3 4 5 6 7
| SELECT devis_habitation.timestamp "Date de génération devis",devis_habitation.timestampAgent "Date de prise en charge de l\'agent",devis_habitation.statut_devis Statut, devis_habitation.timefinish "Date de conclusion",client_particulier.nom Nom, client_particulier.prenom Prénom,devis_habitation.conclusion Conclusion,devis_habitation.comments Commentaire, agents.cabinet Cabinet,agents.titulaire Titulaire, agents.ville "Ville agent",devis_habitation.id_devis_habitation, devis_habitation.ville, devis_habitation.type, devis_habitation.statut_souscripteur,devis_habitation.prix, devis_habitation.adresse_expeditaiton, devis_habitation.ville_expedition, devis_habitation.email, devis_habitation.code, devis_habitation.id_habitation, devis_habitation.type_forfait, devis_habitation.assurance_debut, devis_habitation.adresse_habitation, devis_habitation.valeur_batiment, devis_habitation.valeur_contenu, devis_habitation.detail, devis_habitation.choix, devis_habitation.visible, devis_habitation.timestamp_real,agents.code, agents.adresse, agents.quartier, agents.tel, agents.fax, agents.email, agents.pass, agents.tel_2, agents.gsm,client_particulier.cin,client_particulier.date_naissance, client_particulier.email, client_particulier.id client_particulier,client.email, client.adresse, client.tel_professionel, client.gsm, client.mot_de_passe, client.situation_familiale, client.nombre_enfants, client.sexe, client.profession, client.client_cnia, client.client_cnia_forfait, client.ville, client.date_creation
FROM `devis_habitation` , `agents` , `client_particulier`, `client`
WHERE devis_habitation.code <>0 AND devis_habitation.code = agents.code AND visible =0 AND devis_habitation.email = client_particulier.email AND client.email = client_particulier.email
UNION SELECT *
FROM `devis_habitation` , `agents` , `client_entreprise`, `client`
WHERE devis_habitation.code <>0 AND devis_habitation.code = agents.code AND visible =0 AND devis_habitation.email = client_entreprise.email AND client.email = client_entreprise.email
ORDER BY timestamp_real DESC |
Partager