Query Creates Read-Only Recordset



I want to delete a set of records within a table and I am using records from
another table as a reference. Table A contains the records I want to delete.
Table B contains the subset of records I'm using to identify the target
records. I have full access rights to both tables but when I run the query

"SELECT tblA.* FROM tblA INNER JOIN tblB ON tblA.ItemNo = tblB.ItemNo"

I get the error "operation must use an updateable query".

If Table A contains 100 records and I want to delete 50 specific records,
and Table B contains only those 50 records that match the target records in
Table A, how to I use Table B to delete the records from Table A?

Thank you for any help!

b


.