DELETE tblPreliminaryVINs.* FROM tblPreliminaryVINs INNER JOIN
tblVehicleJobs ON tblPreliminaryVINs.PVIN = tblVehicleJobs.SerialNum;
The above SQL does not work for me. I get an error
I cannot delete the record(s) because of READONLY
and PERMISSIONS related issues.
I can hilite (select) the record in the table and delete it. I can
use the following SQL to delete record(s) in tblPreliminaryVINs
DELETE tblPreliminaryVINs.* FROM tblPreliminaryVINs;
But I really only want to delete records in tblPreliminaryVINs whose
[PVIN] field has a matching value somewhere in blVehicleJobs's
[SerialNum] field. How do I construct that SQL?