Results 1 to 1 of 1
  1. #1
    Join Date
    Apr 2012
    Posts
    1

    Unanswered: Combine two fields and update table except where Unique

    First time poster and I apologize if this is the wrong place to post. I have a DB with 2 tables that i'm trying to compare. Table 1 has current product catalog information. Table 2 has new product catalog information. Anything not in Table 2 is no longer available and must be removed from Table 1 but I need to export that list first, such as a query.

    I believe its something like find all matching VenNum records in Table 2 only where VenNum and MfrNum from Table 1 match.

    I've attached a picture of the tables from my whiteboard.
    Attached Thumbnails Attached Thumbnails DB-Tables.JPG  

Tags for this Thread

Posting Permissions

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