Re: SELECT 'X'
From: Winbatch <winbatch_at_techie.com>
Date: Wed, 14 Aug 2002 00:26:04 -0400
Message-ID: <ajcm6u$6l1$1_at_bob.news.rcn.net>
Date: Wed, 14 Aug 2002 00:26:04 -0400
Message-ID: <ajcm6u$6l1$1_at_bob.news.rcn.net>
Why doesn't he just do delete from emp where empno=1??
"Steve" <smontgomerie_at_hotmail.com> wrote in message
news:156709aa.0208131231.4879416_at_posting.google.com...
> Hello,
> Having developer trying to run something like this
>
> DELETE FROM EMP
> WHERE (SELECT 'X' FROM emp WHERE empno = 1);
>
> the statement fails with missing expression
>
> I'm unclear on the usage of SELECT 'X'
> an also why does the statement fail?
>
> tks
>
> steve
Received on Wed Aug 14 2002 - 06:26:04 CEST