Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    6

    Unanswered: Delete Query Error

    I am trying to create a query which deletes records from two tables where field A in table 1 is identical to Field B in Table 2. I want the records to be deleted only from Table A but I keep getting the following error every time I try to run:
    'Could not delete from specified tables'

    My code is:

    DELETE AD.*, AD.Name
    FROM GEN, AD
    WHERE (((AD.Name)=[GEN.NTLOGON]));


    Somebody, anybody - please help!

  2. #2
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    Did you try puttin (GEN.LOGON) instead?

Posting Permissions

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