On 05/09/2011 10:38, Pau Marc Muñoz Torres wrote:
> Hi follk
>
> i trying to performe a conditional insert into a table, indeed, what
> i'm trying to do is not insert a record into the table if that record exist
>
> googleling i found something like
>
> insert into XX values (1,2,3) where not exist (select ....);
>
> but i'm having and error near where...
>
Shouldn't it be EXISTS, not EXIST?
Anyway, what is the error you're getting?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie