Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2015
    Posts
    22

    Unanswered: Message "Query too complex"

    Hi All,

    I am trying to combine two queries (PRO3 & PRO4) that will update a table (PRO_TBL) but I am receiving the message "Query too complex". Can someone figure out what it might be?


    INSERT INTO PRO_TBL ( ID, MDATE )
    SELECT PRO3.ID, PRO4.MDATE
    FROM PRO3 INNER JOIN PRO4 ON PRO3.ID = PRO4.ID;

    Thanks

  2. #2
    Join Date
    Oct 2015
    Posts
    22
    Hi All,

    Problem solved by created two separate queries.

    Thread closed.

  3. #3
    Join Date
    Dec 2016
    Location
    Atlanta
    Posts
    3
    Provided Answers: 1
    I solved with the help of:
    In the Tables dialog box, select the table that contains fields that are not being used, and then click Edit.

Posting Permissions

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