I have some code that works in Access but now I want to forward the code to our IT department to make a view in our SQL database.
Could anyone please help me convert it so it is correct for normal SQL and not Access SQL if that makes sense?
I have tried to test it in ORACLE SQL Developer but am getting the error:
Error at line 1, column 25: ORA-00923: FROM keyword not found where expected
SELECT T1.*, (SELECT TOP 1 T3.[SMN_DATEC]-1 FROM (SELECT T2.[DET_NUMBERA], T2.[SMN_DATEC] FROM [CHRISCS_EMSAL] AS T2 ORDER BY [DET_NUMBERA],[SMN_DATEC] ) AS T3 WHERE T3.[DET_NUMBERA] = T1.[DET_NUMBERA] AND T3.[SMN_DATEC] > T1.[SMN_DATEC] ) AS EndDate, T1.[DET_NUMBERA], T1.[SMN_DATEC] FROM CHRISCS_EMSAL AS T1 ORDER BY T1.[DET_NUMBERA], T1.[SMN_DATEC];