Search results

I have two tables. One with multiple records per person (MULTIPLE). One with a single record per person (UNIQUE) (see below samples). I want to update the UNIQUE table based on multiple records/values from the MULTIPLE with various conditions. For example, if any of the records for a given...