Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: Delete queries w/ multiple tables

    When trying to create a delete query using multiple tables (eg. delete all rows out of table 1 that have a field matching a field in table 2). I keep getting an error message saying - "Specify the table containing the records you want to delete". How can I create a query that performs this function?

    Thanks for any help.

  2. #2
    Join Date
    Sep 2003
    The extremely Royal borough of Kensington, London
    From tableA
    where id IN (Select id from tableB)
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts