SELECT CONCAT( "Refproduit",CONCAT(' ',"Designation")) AS

"Refproduit_Designation", "Refproduit" FROM "PROD NET"

SELECT "tblEleves"."EleveID", "tblOeuvres"."OeuvreID", "EleveID" || '+' || "OeuvreID" AS "Combi", "tblOeuvres"."OeuvreTitre", "tblOeuvres"."OeuvreCompositeur" FROM "tblEleves", "tblOeuvres"