Append unmatched query in Access

  • Hi Team,


    I am trying to append the unmatched query but getting the error message as "Duplicate Output Destination".


    What actually am trying is to identify the unmatched line.

    Eg: in table "A" i have 2 records and in table "B" 3 records

    and i want to append/insert unmatched query result in table "A".


    Should compare or match between "Field1" in both the tables.


    I request you to kindly advise on this.


    Note: I will provide the link in case of cross posting.


    Thank you.


    Regards,

    Rehaman.

  • Hi Team,


    Cross posted here "https://www.accessforums.net/showthread.php?t=85165&p=489046#post489046"


    Note : Not able to edit the post.


    thank you.

  • Hi Team,


    Solution has been received from "https://www.accessforums.net/showthread.php?t=85165&p=489055#post489055"


    Thank you.


    Regards,

    Rehaman.

  • INSERT INTO TableA

    SELECT TableB.* FROM TableB LEFT JOIN TableA ON TableB.ID=TableA.ID

    WHERE TableA.ID is null

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!