SELECT
    DATE
  , "Client".nom as client
  , "Lieu".nom as lieu
  FROM "Facture"
  JOIN "Panier" ON "Panier".facture = "Facture".ID
  JOIN "Client" ON "Client".ID = "Panier".ID
  JOIN "Lieu" ON "Lieu".ID = "Client".lieu
  --WHERE ID = '###FORMFIELD(<Clients><Factures><FacturesControl><ID>)###'
;
