Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    12

    Unanswered: Automation of query to compare two tables of data..

    Sorry guys, I'm a new programmer.. i am really new... Please bear with me, i know i'm gonna irritate u guys soon but i dun mean to!

    I have a table in Access97. Let's call this Orange Table . It contains of data i want to compare with soon-to-be access table data.

    I'm going to extract a list of component numbers from a program-SAP. And i have a lot of lists of component numbers from this program that i need to extract. So i need a automated program to compare data and output difference.
    Then from there, i'll go to access97 and "Get External Data" from the list of component numbers i extracted. Let's call this Red Table .

    From Orange Table of data, i'll need to compare them with Red Table , then output missing component numbers that Red Table has.
    EG: If Red Table got component number 514784-00 and Orange Table doesn't have, then i'll need to output the component number out[in any form]. However, if Orange Table has 154879-00 while Red Table doesn't have, then dun need to output them!

    How to go about designing the "Union Query" for automation of such comparing of datas just between two tables... That's all.. Please help me...
    There no other place better than this... http://wenz.alexlab.com

  2. #2
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    NOT IN

    SELECT * FROM RED_TABLE
    WHERE component_number NOT IN
    (SELECT component_number FROM ORANGE_TABLE)



    with this youll get all the info From Red hat isnt in Orange

Posting Permissions

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