Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2005
    Posts
    1

    Unanswered: error: join expression not supported

    Hi,
    I get the following error when sql sting (ADO) running in vusual basic on db Access:

    Error run–time –2147217900 (80040e14)
    Join expression not supported

    Query:
    D = "DELETE TSNOTES.* " _

    & "FROM ((TSNOTES LEFT JOIN TS ON TSNOTES.tsID = TS.tsID) LEFT JOIN WACOMM ON TS.tsWAID = WACOMM.wacommID) LEFT JOIN ABSN ON TS.tsWAID = ABSN.absnID" _

    & "WHERE (TS.tsType=6 AND WACOMM.wacommID Is Null) OR (TS.tsType=8 AND ABSN.absnID Is Null);"


    Why???????
    Thanks,

    Besso
    Attached Thumbnails Attached Thumbnails QuerySemp.gif  

Posting Permissions

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