Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Joff01

    DELETE the contents of a SELECT statement

    I've used ON DELETE CASCADE before with Oracle, but I'm not even going to see if Access supports it :)
  2. Joff01

    DELETE the contents of a SELECT statement

    Right, I've sorted it now - thanks for both your help. You were right, I just wasn't deleting from each table!!
  3. Joff01

    DELETE the contents of a SELECT statement

    Ah, ok. The thing is, the SELECT is using a couple of inner joins to link multiple tables, so I can't specify a table to delete from as there's several.
  4. Joff01

    DELETE the contents of a SELECT statement

    Hi, I'm trying to delete all the records returned in a SELECT statment, but I can't seem to get the syntax right. I've tried: DELETE * FROM (SELECT * FROM table_x WHERE field_x = x) and DELETE FROM (SELECT * FROM table_x WHERE field_x = x) But neither seem to do the trick. If it's of any...
  5. Joff01

    U.K. date problem..

    I'd be interested to know what you did to sort it! Jonathan

Part and Inventory Search

Back
Top