Josué Maldonado <josue(at)lamundial(dot)hn> writes:
> Hello list,
>
> Could anyone point me the rigth way to write this query:
>
> INSERT INTO ped_cam
> (SELECT * from ped_pro where ped_pk=lnpedpk)
> WHERE NOT EXISTS (SELECT ped_pk FROM ped_cam
> WHERE ped_pk=lnpedpk);
>
> I got this:
> ERROR: syntax error at or near "WHERE" at character 63
You've misparenthesized.
-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863