Looking for some help with a SELECT query please.

I have two tables of data, each table has a reference column in it which is what matches the data.
Table 1 contains product information and Table 2 contains discount information on the products.

I am trying to set up a query which will only show items from Table 1 where a discount for that item is set in Table 2.
I've had a look at some of the SQL JOIN statements but I can't get them to work correctly

Can anyone help me with this please?

Thanks in advance