Can I use a join in an UPDATE query?
Posted: Fri Feb 18, 2005 1:26 am
Yeah ... I have a feeling this is a dumb question, but I thought I might as well ask.
The issue is that I have two linked tables which hold a value I want to update, but the value is in table 1 and the ID I have access to is from table 2. Oh yeah, and the ID I have isnt the key used to join these tables.
In order to save a query to match the two tables, I'm kind of wanting to say UPDATE blah WHERE table1.key = table2.key AND table2.ID = 8.
Is this even remotely possible?
Thanks
The issue is that I have two linked tables which hold a value I want to update, but the value is in table 1 and the ID I have access to is from table 2. Oh yeah, and the ID I have isnt the key used to join these tables.
In order to save a query to match the two tables, I'm kind of wanting to say UPDATE blah WHERE table1.key = table2.key AND table2.ID = 8.
Is this even remotely possible?
Thanks