I may not have explained what I am looking for well in the the title, but this is what I am trying to accomplish.
I have results from 1 query (see below), and I want to update all of the records in TableB that have the same ID as the results from the select statement. For example, if the query returns 3 IDs, I want to take those and update the records in TableB based on those IDs. (Update TableB... set somevalue='blah'... etc.
I know this can be done a few different ways in coldfusion or even just using the SQL. I just need a rough example.
Thanks for any help you can offer
SELECT TableA.TheID, TableB.AValue, TableA.AUser,
FROM TableA INNER JOIN
TableB ON TableA.TheID = TableB.TheID