We have a rather large table that needs to be updated/inserted with a datefield value from another table. This needs to be done only once.
Table 1 is about 30K records.
Table 2 is about 120 records.
Table 1 (that needs to be updated) is linked to Table 2.
I'm pretty sure there is a rather simple solution to this conundrum but I can't figure it out.