CREATE TEMPORARY LOCAL TABLE T_USR 
AS ( SELECT USR_PRENOM, USR_NOM, 
            USR_USER_EMAIL || '@' || DNS_NAME AS DEMAIL
     FROM   S_ADM.T_UTILISATEUR_USR AS U
            JOIN S_ADM.T_DNS AS D ON U.DNS_ID = D.DNS_ID)
WITH DATA;


/*

--> pour SQL Server

SELECT USR_PRENOM, USR_NOM, USR_USER_EMAIL || '@' || DNS_NAME AS DEMAIL
INTO T_USR 
FROM   S_ADM.T_UTILISATEUR_USR AS U
       JOIN S_ADM.T_DNS AS D ON U.DNS_ID = D.DNS_ID);

*/
