Subject Re: [firebird-support] Transactions
Author Saunders, Rich
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.


Rich Saunders