Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012
    Posts
    2

    Unanswered: Please help convert to Oracle

    Hello all,

    Can someone please "convert" this to Oracle? I think it's an issue with the inner join:

    SELECT batchcatalog.BatchName, batchcatalog.ClassName, BatchField.DocID AS "Document Number", indexfield.Name AS "Field Name", BatchField.Value AS "Field Value", UserFldDef.Name AS "Batch Field Name", UserField.Value
    FROM BatchField AS BatchField INNER JOIN
    BatchCatalog AS batchcatalog ON batchcatalog.ExternalBatchID = BatchField.BatchID
    INNER JOIN
    IndexField AS indexfield ON indexfield.IndexFieldID = BatchField.IndexFieldID
    INNER JOIN
    UserField ON BatchField.BatchID = UserField.BatchID
    INNER JOIN
    UserFldDef ON UserField.UserFldDefID = UserFldDef.UserFldDefID
    WHERE (batchcatalog.BatchName = '5/3/2012 9:37:06 AM')

    getting ORA00933


    Thank you!!

    Rich

  2. #2
    Join Date
    May 2012
    Posts
    2
    Figured it out, disregard!!

    Thanks!!

Posting Permissions

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