Need SQL syntax

Results 1 to 2 of 2

Thread: Need SQL syntax

  1. #1
    Join Date
    Dec 1969

    Default Need SQL syntax

    Need SQL syntax to insert records into one table from another table. Both tables are identical.<BR><BR>I don&#039;t remember the exact syntax, thought it was something like insert into table1 from (select * from table2) but it is not working...<BR><BR><BR>Thanks,<BR>-- Whol

  2. #2
    Join Date
    Dec 1969

    Default RE: Need SQL syntax

    INSERT INTO Table1 (FieldA, FieldB, FieldC)<BR>SELECT FieldA, FieldB, FieldC<BR>FROM Table2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts