Skip to main content
A
Anonymous
May 19, 2008
Answered

Query of Queries

  • May 19, 2008
  • 11 replies
  • 924 views
I have 2 tables in 2 different Datasources

one is a small table with 300 records the other one is a massive table with 970,000 records

I need to validate the data from table 1 against table 2

Thanks in advance
    This topic has been closed for replies.
    Correct answer Dan_Bracuk
    Your query 123 (by the way, I don't think you can start a query name with a number), gives you the matching records. The non matching records are the ones from query abc that are not in query 123.

    That's the logic. I'll leave it to you to translate that into syntax.

    11 replies

    Show previous replies
    C
    Casatap
    Inspiring
    May 20, 2008
    Can you give some more information about how you need to validate? What are some pertinent columns?
    A
    Anonymous
    May 20, 2008
    tableA(300 records)
    ID
    Fname
    Lname
    MI
    Address
    Flag

    tableB(970,000 records)
    ID
    Fname
    Lname
    Hiringdate

    So I need to see if ID and Fname on tableA matches tableB if so
    copy those record to tableC if not flag them on tableA as "NM" (NoMatch)
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices