I have two tables, table one has records that are entered daily, and table two that has a master set of values used in the table one. I need to identify in table one what values in table two that not found in table one for each subset of records created daily.
Table one: Table two:
I need to show on the day the records in table one were created that 0007-0111 was not used in a record in table one on this day.
thanks for the help in advance.