filter table 2 based on table 1

I have two tables of data.  Table 1 has date, eqnum and status  plus other columns. Table 2 has date, eqnum and trouble report plus other columns.   I would like to use a visual (table) to show th...