6 Replies Latest reply on Jun 20, 2012 12:09 PM by BoydReilly

    Import Records 2 Fields into 1 Field



      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?