Subquery failing - is there an alternative?

[Dan Horne]

Hi All

I'm trying to run the following subquery but it returns an error that says
"cannot recognize input near 'select' 'max' '(' in expression specification"

select id,

first_name,

last_name,

change_seq

from person_source

where change_seq >

(select max(change_seq) from person_target);


If I replace the sub query with the actual maximum change_seq it works.


Is there another construct that should work?


Regards


Dan