Re: Insert into sintax

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

Thanks,

--
Sinceramente,
Josué Maldonado.
"¿Porqué es tan difícil <querer>, mientras es tan fácil <desear>? Porque
en el deseo se expresa la impotencia, y en el querer, la fuerza. "

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