Results 1 to 5 of 5

Thread: Delete & Joins

  1. #1
    Join Date
    Aug 2011
    Posts
    3

    Unanswered: Delete & Joins

    I am having trouble getting this to run... can anyone help me out?
    I get this error: ORA-00933: SQL command not properly ended
    and points to the INNER word in red below

    delete from table1 a
    inner join table2 s
    on a.ponbr = s.ponbr
    inner join table3 h
    on a.ponbr = h.ponbr
    inner join table4 n
    on a.ponbr = n.ponbr
    where a.revnbr < h.revnbr
    or (a.revnbr = h.revnbr
    and a.date < n.date
    and (a.itemnbr = n.itemnbr and a.name = n.name));


    Any ideas??

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    it appears your version of Oracle does not ANSI syntax so convert SQL to non-ANSI syntax
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2011
    Posts
    3

    ?

    Quote Originally Posted by anacedent View Post
    it appears your version of Oracle does not ANSI syntax so convert SQL to non-ANSI syntax
    Doesn't 10g support Ansi sytax? That is the database version that is currently being used.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Doesn't 10g support Ansi sytax?
    In theory V10 is supposed to support ANSI syntax.
    In reality the error indicates otherwise; at least for DELETE.
    You are free to submit Service Request to MOS, for official resolution.
    In the mean time, if you desire to proceed, I suggest you work around the error as best you can
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Aug 2011
    Posts
    3

    Re: ?

    Ok thank you!

Tags for this Thread

Posting Permissions

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