Re: Insert into sintax

Duane,

El 05/08/2004 5:29 PM, Duane Lee - EGOVX en su mensaje escribio:
> What table is lnpedpk in - ped_cam?  What table is ped_pk in - ped_pro and
> ped_cam?

lnPedPk is parameter pased to the function and it could be a fixed value
on the sql console too, ped_pk is common in both tables, I changed the
code to this and still get the same error

INSERT INTO ped_cam
      (SELECT * from ped_pro where ped_pro.ped_pk=81178)
      WHERE NOT EXISTS
    (SELECT 1 FROM ped_cam WHERE ped_cam.ped_pk=81178);

Thanks,


--
Sinceramente,
Josué Maldonado.
"Deja que los perros ladren, Sancho, es señal que caminamos." -- Miguel
de Cervantes Saavedra.