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);