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

    Import Records 2 Fields into 1 Field

    BoydReilly

      Title

      Import Records 2 Fields into 1 Field

      Post

      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?

       

      TIA.