I am using 2.6, although I have 7.0(it's a migrataion thing).
My question:
Using the sql select statement, is there any way to write to the results, and update the database?
example
I have 1000 different locations, with several customers for each location. I want to tag 1 record for each location.
There are several ways to do this, but I was hoping to discover a way to write directly to the data that meets the criterea. Any help?