AnsweredAssumed Answered

Import Records 2 Fields into 1 Field

Question asked by BoydReilly on Jun 20, 2012
Latest reply on Jun 20, 2012 by BoydReilly


Import Records 2 Fields into 1 Field


I am using the Import Records function to load records from Customers to a NewCustomers file where I’d like to take the LastName and FirstName field from Customer and load it into NewCustomers field UserName like Lastname, FirstName.  Here is my current SQL Text:


SELECT "Customers"."Id", "Customers"."LastName","Customers"." FirstName", "Customers"." Level", (" Customers"."LastName"+ “Customers"."FirstName")
FROM "Customers" where "Customers"."level"=4


It won’t accept this statement.  Can someone tell me the correct text here?