On 2014-04-12 18:56, Helen Borrie wrote:

> At a minimum you need
>
> Select P.product,SI.Rec_ID
> FROM stores S,Products P
> LEFT JOIN Stores_Inventory SI ON (S.Rec_ID = P.something)
>
> and if you want the join value to be limited to Rec_ID =12 then
> provide the WHERE clause:
>
> WHERE S.Rec_ID = 12

I think you need a join between S and P and another between S and SI.
Then you can add the WHERE clause from above.

--

Cheers!
Rich Saunders