Delete query to clear records from one table with key linked to an

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all.

I kind of got stuck with this one.

I'm trying to use a Delete query to delete some records from Table A.

Let's say Table A has three fields: A1, A2 and A3

Then there's another table, Table B, with two fields: B1 and B2

Within one Delete Query, i need to delete all the records from Table A for
which: A1=B1

Thanks for your help.

Alex
 
Right!

No way i could get this to work with an inner join kind of setup.
Thanks Niko

yg: viva patrida
 
Back
Top