Re: missing FROM-clause entry for table bbbb

2018-01-16 Thread David Rowley
On 17 January 2018 at 00:36, Abhra Kar wrote: > insert into (id, groupid, ele_id, ro_element_id) ") > select .nextval, :groupid, gosp.neteleid, gosp.hodev >from net_ele gos, net_gos_prop gosp " >where gos.eid in ( :eids ) and gos.id = gosp.net_element_id

Re: missing FROM-clause entry for table bbbb

2018-01-16 Thread David G. Johnston
You should pick one list to post to. On Tue, Jan 16, 2018 at 4:36 AM, Abhra Kar wrote: > Hi > I tried to modify below sql command in postgres syntax--- > > insert into (id, groupid, ele_id, ro_element_id) ") > ​That ") looks wrong...​ select .nextval, :groupid, gosp.net