SQL Server query om til Oracle
Hejsa,Er der en Oracle-haj der kan lave følgende MS-SQL query om til Oracle syntax?
SELECT ConsSubmission.SubmissionName,
ConsSubmission.TotalHomeAmount,
ConsSubmission.NickName, CapUser.LoginName AS UserInit,
ConsSubmission.SubmissionStatus,
CapUser.FirstName AS UserFirst,
CapUser.LastName AS UserLast,
ConsSubmission.SubmitDate,
ApprUser.LoginName AS ApprInit,
ApprUser.FirstName AS ApprFirst,
ApprUser.LastName AS apprlast
FROM ApprovalPosition ApprAppr INNER JOIN
ApprovalPosition UsrApprPos ON
ApprAppr.ApprovalPositionID = UsrApprPos.ApprovalPositionSupervisorID
INNER JOIN
CapUser ApprUser ON
ApprAppr.CapUserID = ApprUser.CapUserID RIGHT OUTER JOIN
ConsSubmission INNER JOIN
CapUser ON
ConsSubmission.CapUserID = dbo.CapUser.CapUserID ON
UsrApprPos.ApprovalPositionID = dbo.ConsSubmission.ApprovalPositionID
WHERE (ConsSubmission.SubmissionStatus NOT IN (4, 5));