We know how to use SQL UPDATE commands (e.g. UPDATE SET Field='Value WHERE etc.)
However we are wanting to UPDATE many records on mass
e.g. UPDATE a table of multiple records and a unique primary key with values from another table with the same common unique primary key in several records
Is this at all possible, and if so can you post some code that work, ohterwise the only other option is to scan thru every record in Table A, get it's Primary Key and then update from the 2nd table. When we have 10,000 records that'll prove a bit typesome!!