Results 1 to 21 of 21
Apr 10, 2014, 09:12 #1
- Join Date
- Dec 2005
- 0 Post(s)
- 0 Thread(s)
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