Update Statment Help using JOINS?
Posted on 2007-10-05
Okay so I know how to select data from tables using Joins but how do I update whilst using this principle.
Eg. I have 3 tables, 1: Stock, 2: StockToRecords, & 3: Records
I could do this in a select
SELECT records.recid from records
INNER JOIN StockToRecords ON Records.RecID = StockToRecords.RecID
INNER JOIN Stock ON StockToRecords.Partno = Stock.Partno
where Stock.Partno = 'banana'
So I can select based on the Stock table but how using this relation as above would I update a column in records using a where clause from stock?
Thanks in advance,