TimeXtender has a feature called Custom Table Insert. This feature allows user to add data to a table based on a custom SQL query
To use this feature, right-click the table you want to add data to, select Advanced, and then select Add Custom Table Insert.
In the script editor, create a SQL SELECT statement - no INSERT clause is necessary. The script should look like this:
SELECT [FirstName], [MiddleName], [LastName], [FullName] AS [Full Name] FROM [Person]
If the field names in the source tables are different from the field names in the destination table table, use an alias to make the names match up.