exp vg
asked on
Access - Delete Query - Based on Two Tables
I have one main source Table A from which I want to delete records from that have the same ID's in a Table B. Table A has more ID's than Table B - so Table B ID's are a subset of Table A.
I have tried to create a join between ID's in Table A and Table B, indicating to delete the ID's in Table A that are also in Table B, without success.
Please offer suggestions on how to delete ID's from A that are also in B.
I have tried to create a join between ID's in Table A and Table B, indicating to delete the ID's in Table A that are also in Table B, without success.
Please offer suggestions on how to delete ID's from A that are also in B.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.