Please try with subquery alias .
Regards
On Mon, Dec 9, 2019, 6:06 AM Dan Horne <dan.ho...@redbone.co.nz> wrote:
> 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) A;
>
>
> If I replace the sub query with the actual maximum change_seq it works.
>
>
> Is there another construct that should work?
>
>
> Regards
>
>
> Dan
>
