Is the error I am getting when running the following query:
Code:
UPDATE tbl_Lakes INNER JOIN qry_SelectLakes ON tbl_Lakes.ULID=qry_SelectLakes.ULID SET tbl_Lakes.Perimeter = qry_SelectLakes.Perimeter;
this is what qry_SelectLakes looks like, and it runs successfully by itself:
Code:
SELECT ULID,Perimeter
FROM LP02AA
UNION SELECT ULID,Perimeter
FROM LP02AB
UNION SELECT ULID,Perimeter
FROM LP02AC
UNION SELECT ULID,Perimeter
FROM LP02AD
UNION SELECT ULID,Perimeter
FROM LP02AE
UNION SELECT ULID,Perimeter
FROM LP02BA
UNION SELECT ULID,Perimeter
FROM LP02BB
UNION SELECT ULID,Perimeter
FROM LP02BC
UNION SELECT ULID,Perimeter
FROM LP02BD
UNION SELECT ULID,Perimeter
FROM LP02BE
UNION SELECT ULID,Perimeter
FROM LP02BF
UNION SELECT ULID,Perimeter
FROM LP02CA
UNION SELECT ULID,Perimeter
FROM LP02CB
UNION SELECT ULID,Perimeter
FROM LP02CC
UNION SELECT ULID,Perimeter
FROM LP02CD
UNION SELECT ULID,Perimeter
FROM LP02CE
UNION SELECT ULID,Perimeter
FROM LP02CF
UNION SELECT ULID,Perimeter
FROM LP02CG
UNION SELECT ULID,Perimeter
FROM LP02CH
UNION SELECT ULID,Perimeter
FROM LP02DA
UNION SELECT ULID,Perimeter
FROM LP02DB
UNION SELECT ULID,Perimeter
FROM LP02DC
UNION SELECT ULID,Perimeter
FROM LP02DD;
Does anyone know why I might be getting this error?
Thank-you!