Two tables:

Table1 `fax_history`

```
fax_key
1001
1002

```

Table2 > `fax_history_status`

```
fax_key     Status
1001        NEW
1001        SUCCESS
1002        NEW

```

Now I need to write a `join query` which will return only `fax_key=1002` record because `fax_key=1001` has MORE THAN ONE record in `fax_history_status` table.

So the query result should be:

```
fax_key     status
1002        NEW

```