modèles/Facture.Facture.sql

   1 SELECT
   2     DATE
   3   , "Client".nom as client
   4   , "Lieu".nom as lieu
   5   FROM "Facture"
   6   JOIN "Panier" ON "Panier".facture = "Facture".ID
   7   JOIN "Client" ON "Client".ID = "Panier".ID
   8   JOIN "Lieu" ON "Lieu".ID = "Client".lieu
   9   --WHERE ID = '###FORMFIELD(<Clients><Factures><FacturesControl><ID>)###'
  10 ;