and gos.id = gosp.net_element_id and
gos.id not in (select ealjs.element_id from ealjs where
ealjs.groupid = :groupid)
If I run this it gives error for ":".If I remove : then I will get error
like missing FROM-clause entry for table .
What is the issue here and what shou
= gosp.net_element_id and
> gos.id not in (select ealjs.element_id from ealjs where
> ealjs.groupid = :groupid)
>
> If I run this it gives error for ":".If I remove : then I will get error
> like missing FROM-clause entry for table .
.nextval l
ealjs.groupid = :groupid)
>
> If I run this it gives error for ":".If I remove : then I will get error
> like missing FROM-clause entry for table .
>
>
How are you executing the query, in what client program. If it is psql
did you define the variable groupid and eids p
