You might look at 2 possibilities:
1. The FROM clause should be up against the LEFT hand column
(I think ????)
2. If the FROM clause is a join, then you must define specifically which
TABLE.ROWNUM
Good Luck
NICK MOSCARITOLO
Bentley College