SQL Query

• eislerandi

  SSC Journeyman

  Points: 82

  More actions

  July 24, 2002 at 7:21 am

  #78715

  We have imported tables from Excel and Access and now want to insert date from temporary import tables to our DB. We have to import data of columns A and B from one source and column C with data of another one.

  eg: EmployeeName and Address from Table1 and the fees from Table2

  INSERT INTO staff.EmployeeName, staff.Adresse

  SELECT EmployeeName, Address FROM Table1

  this does not work, cause insert-select does not support column selection within the insert statement.

  Any hints?

• apinnelli

  Mr or Mrs. 500

  Points: 525

  More actions

  July 24, 2002 at 8:19 am

  #433291

  HI,

  correct syntax is:

  INSERT INTO staff (staff.EmployeeName, staff.Adresse)

  SELECT EmployeeName, Address FROM Table1

  bye Antonio