insert with append

• stanny

  Newbie

  Points: 1

  More actions

  February 15, 2005 at 7:48 am

  #162646

  I have a table called name1 and this table has 2 columns firstname, lastname.

  I have a 2nd table called name2 with 3 columns firstname, lastname, email.

  I want to take the contents of table 1 and add to table 2 which is easy enough.  However i want colunm 3 on the 2nd table to read like the below.

  firstname.lastname@test.com

  I know this is probably pretty simple, but i am pretty new to this.

• Jim P.

  SSCrazy Eights

  Points: 8725

  More actions

  February 15, 2005 at 8:09 am

  #542293

  Welcome to the madhouse.

  INSERT INTO table2 (firstname, lastname, email)
  SELECT  firstname, lastname,  
         firstname + '.' + lastname + '@TEST.COM' AS email
  FROM table1

  
  
  ----------------
  Jim P.

  A little bit of this and a little byte of that can cause bloatware.