DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: re:Stored Procedure

  1. #1
    Join Date
    Nov 2001
    Location
    Visalia, California
    Posts
    20

    Angry

    Converting some Access SQLs into Oracle Stored procedures, and I seem to be haveing a problem could you please help. Here is the Access SQL.

    SELECT DISTINCTROW Fee_Id.Number_Key AS Permit, FEE_SUM.Receipt_No AS Receipt, FEE_TRN.Method, FEE_SUM.Notation, FEE_SUM.Initials, FEE_SUM.User_Id, FEE_DETL.Amount
    FROM (((Fee_Id INNER JOIN FEE_SUM ON Fee_Id.Trans_Id = FEE_SUM.Trans_Id) INNER JOIN FEE_DETL ON FEE_SUM.Trans_Id = FEE_DETL.Trans_Id) INNER JOIN FEE_TRN ON FEE_DETL.Trans_Id = FEE_TRN.Trans_Id) INNER JOIN TRU_DETL ON (FEE_TRN.Trans_Seq = TRU_DETL.Trans_Seq) AND (FEE_TRN.Trans_Id = TRU_DETL.Trans_Id);

  2. #2
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    You need to edit this a bit - for example use DISTINCT instead of DISTINCTROW. Also inner joins in oracle are just equijoins. So get rid of all the extra text.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

Posting Permissions

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


Click Here to Expand Forum to Full Width