SELECT statement from more than 1 table
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