Bob Pawley wrote: > I am receiving an error message about a missing "From Clause" in an > insert statement. > > I've tried a number of variations of adding a from clause with no success. > > Could someone help with the following statement?? > > Insert Into p_id.loop_sequence (monitor) values(p_id.loops.monitor) ; You can add that schema name to your search ppath, you know... saves typing. What kind of value is p_id.loops.monitor? I think you meant to do a select instead of values; probably this: set search_path to 'p_id,public'; insert into loop_sequence (monitor) select monitor from loops; > Bob Pawley -- Alban Hertroys alban@xxxxxxxxxxxxxxxxx magproductions b.v. T: ++31(0)534346874 F: ++31(0)534346876 M: I: www.magproductions.nl A: Postbus 416 7500 AK Enschede // Integrate Your World //
