I have a table AVI with the following relevant structure:
POLY_NUM key
LKP
SITE1
SITE2
SITE3
Y2BH

I have a lookup table SILKP with:
LKP
SITE1
SITE2
SITE3
Y2BH

what is the fastest/most efficient way to update table A SITE1-SITE3 and Y2BH fields by linking via lookup.

What I have:

Code:
with sqlite3.connect(db_filename) as conn:
...