Re: SQL about "as"

From: Mike Daniell <mike_at_helix.com.au>
Date: Fri, 20 Nov 1998 12:26:48 +1000
Message-ID: <3654D368.9E72B4B8_at_helix.com.au>


Drop the "as". Also, use single quotes around literals, ie

         select T.branchname
         from branch T
         where T.branchname='city';

Regards,
Mike

Ken Ho Kwok Fai wrote:
>
> I am using oracle 8 in unix. I write the following
> SQL but it seems to have some problems.
>
> select T.branchname
> from branch as T
> where T.branchname="city";
Received on Fri Nov 20 1998 - 03:26:48 CET

Original text of this message