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 the Info from Table 1 and the related count from Table 2.  Where the count is the number of rows where the date and eqnum match.

Like:

Date, Eqnum, Status, Count

Is there a way to do this?