Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Kalamazoo
    Posts
    42

    Angry Unanswered: Error while Inserting

    Hey folks,
    I am trying to updat a table by inserting values from another table into the parent table. The SQL being used is:
    "insert into "LogSchema"."_rt1182" select * from "LogSchema"."_rt557" where recordID not in (select * from "LogSchema"."_rt1182") ORDER BY TIMESTAMP"
    I have used the above statement and was successful, but with these two particluar tables I am getting an error message" Wrong number of values to INSERT"
    Please lemme know, what this means and how to correct this problem!
    TIA

  2. #2
    Join Date
    Apr 2004
    Posts
    4
    try not using * but fields by their respective names....

Posting Permissions

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