AnsweredAssumed Answered

Looking for values from one table that are not in another table

Question asked by jlcalhoun61 on Dec 7, 2017
Latest reply on Dec 7, 2017 by philmodjunk

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.

 

Example:

 

Table one:                                                  Table two:

room_location                                             room_location_lookup

0007-0108                                                    0007-0108 

0007-0108                                                    0007-0109  

0007-0109                                                    0007-0110

0007-0110                                                    0007-0111

 

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.

Outcomes