Link to home
Start Free TrialLog in
Avatar of exp vg
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.
ASKER CERTIFIED SOLUTION
Avatar of Mark Bullock
Mark Bullock
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial