it's not a syntax or case error.

I dont' change the top select part of the statement.

I simply comment out the last table and the statement works.

As soon as i include more than two tables in a join and use a top n , Oracle returns an error.