For ( name ,  company , website ...)  I will  Manage these fields  on UsersAccount/ Manage Profile Properties By adding New Items .

I need Trigger just for adding basic informations to my customer table to attach my module (working with customer Table DataSet) to Dnn_users Table

For trigger I tried that :

CREATE TRIGGER Insert_into_customer on Users u,UserRoles ur
   FOR INSERT
     AS
    INSERT INTO customer(custid, compagny,mail)
    SELECT (ur.UserRoleID,u.Username,u.Email
    WHERE ( u.UserID=ur.UserID))
    FROM inserted ;

So when I try to execute it under Host> SQL  , I have this following error message: There is an error in your query!

When the case run as Script is cheked , I get this Error :

System.Data.SqlClient.SqlException: Incorrect syntax near ','. Incorrect syntax near ','. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE TRIGGER Insert_into_recruteur on Users u,UserRoles ur FOR INSERT AS INSERT INTO Recruteur(idrecruteur, raisonsociale,mail) SELECT (ur.UserRoleID,u.Username,u.Email WHERE ( u.UserID=ur.UserID)) FROM inserted ;

Needing Help Please.