Yes, but from what I remember (Razzak's reply is on a different PC so I may
misquote) AS followed each column name in the CREATE VIEW example as per Dr.
R>. I created the view using CREATE VIEW (<alias column names) <column
names...>
Is there a difference?
Dan
----- Original Message -----
From: "Troy Sosamon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 2001 9:41 AM
Subject: RE: Strange problem with a view - Razzak's Reply
> When you use AS, you are aliasing column names. INTO puts the selected
> column into a variable.
>
> Example 1, I want get the quantity of something and put it in a var
> set var vtotal int = 0
> select count (*) into vtotal from sometable where ....
>
> Example 2, I want to do quick report using a select and total widgets, but
I
> want meaningful col headings:
>
> select t1.client, (sum(t2.widgets))=s as my_client, total_widgets from
> clients t1, widgets_sold t2 where t1.client_id = t2.client_id group by
> client
>
> Troy
>
> ===== Original Message from [EMAIL PROTECTED] at 9/25/01 7:41 am
> >Could you please explain the difference between AS and INTO in a select
> >command.
> >
> >Also in a previous post someone mentioned a function GETCLIP (to get
data
> >from the windows clipboard). I cannot find the syntax for that at
> >R.Syntax.com.
> >
> >Bernie Lis
> >
> >> name all columns AS ALIAS name(s).
> >>
> >> Example:
> >>
> >> DROP VIEW Maximum
> >> CREATE VIEW tMaximum AS SELECT (MAX(CHARGE)) AS MaximumCharge +
> >> FROM TableName ...
> >>
> >> For more details and examples on CREATE VIEW: http://www.RSyntax.com
> >>
> >> Have Fun!
> >>
> >> Very Best Regards,
> >>
> >> Razzak.
> >>
> >> ===================================-============================
> >> R:BASE Developers's Conference: http://www.rbase.com/conference
> >> Official R:BASE List Server: mailto:[EMAIL PROTECTED]
> >> RBTI Events/Training: http://www.rbase2000.com/events
> >> R:DCC Members: http://www.rbase2000.com/rdcc
> >> ================================================================
> >> R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
> >> ==================================-=============================
>
>
