Hello,
I'm having some trouble converting a database from MySQL to Oracle.
The following statement works fine in MySQL:
SELECT SUM(takeover_points) FROM takeover_points as t3
JOIN (SELECT t1.takeover_id, takeover_user_id, takeover_update_id, takeover_sent, takeover_canceled, takeover_failed, takeover_created, takeover_severity
FROM takeover_scheduled_updates AS t1
JOIN takeover_available_updates AS t2
ON t2.id = t1.takeover_update_id
WHERE takeover_canceled = 0 AND takeover_failed = 0 AND takeover_user_id IN (
SELECT takeover_uid FROM takeover_users WHERE takeover_fbid = 'xxxxxxxx')) AS t4
ON t3.takeover_severity = t4.takeover_severity;
When I'm running it on Oracle I am getting the following Error:
ORA-00933: SQL command not properly ended
Anyone knows what I need to change to make this work?
Thank you!