Results 1 to 2 of 2

Thread: delete query ?

  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: delete query ?

    Hi,

    Is this a valid SQL Server query :

    DELETE FROM D FROM D WHERE LEFT JOIN H ON H.key=D:key WHERE H.key IS NULL

    Please advise.

    Thanks,
    Sam

  2. #2
    Join Date
    Mar 2004
    Posts
    205
    Please ignore the above query, this is invalid, as I have type as 'd:key'. Please see my next post to this.

Posting Permissions

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