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.