Join two tables, add check to new column if value found, and remove duplicates (plus bonus stuff)
The following solution shows how you can query two tables in a DB2 database for user IDs that have a password older than 90 days and are in the “LOCKED” group. We will need to join the tables but a simple JOIN won’t do as we get may rows for the same user. This is due to group membership… Read More »