Specify the join criterion and subset the query. The WHERE clause specifies that the tables are joined on the ID number from each table. WHERE also further subsets the query with the IN condition, which returns rows for only four employees.


       where idnumber=idnum and idnum in 
              ('1919', '1400', '1350', '1333');