[RBASE-L] - Re: Creating a view with an ALIAS computed column in Rbase 8

[Bill Downall]

Bill,
There are two ways:

1)

CREATE VIEW 'TrialLayout1' AS SELECT +
 T1.Trial, +
 T2.entry, +
 T3.PlotNum, T3.Entry, T3.RepNum, T3.blockNum, +
 ((INT(trial)*10000 + PlotNum)) AS TrialPlot +
 FROM trialNo T1, trial T2, Randomization T3 +
 WHERE +
 T1.trial = T2.trial AND T1.randNum = T3.randNum AND T2.entry = T3.entry

2)

CREATE VIEW 'TrialLayout1' +
(Trial, TrialEntry, PlotNum, BlockEntry, TrialPlot) +
AS SELECT +
 T1.Trial, +
 T2.entry, +
 T3.PlotNum, T3.Entry, T3.RepNum, T3.blockNum, +
 ((INT(trial)*10000 + PlotNum)) +
 FROM trialNo T1, trial T2, Randomization T3 +
 WHERE +
 T1.trial = T2.trial AND T1.randNum = T3.randNum AND T2.entry = T3.entry

Bill

On Thu, Jan 8, 2009 at 11:08 AM, Bill Niehaus <bnieh...@crystalsugar.com>wrote:

>  I am creating a view in Rbase 8 with a computed column.  I am trying to
> give the computed column an ALIAS for easier reference, but haven't figured
> out the syntax for that.
>
> This creates the view ok, but it gives a long column name.
>
> CREATE VIEW 'TrialLayout1' AS SELECT +
>  T1.Trial, +
>  T2.entry, +
>  T3.PlotNum, T3.Entry, T3.RepNum, T3.blockNum, +
>  ((INT(trial)*10000 + PlotNum)) +
>  FROM trialNo T1, trial T2, Randomization T3 +
>  WHERE +
>  T1.trial = T2.trial AND T1.randNum = T3.randNum AND T2.entry = T3.entry
>
>
> How would I assign an alias "TRIALPLOT" to the computed column
> ((INT(trial)*10000 + plotnum)) ?
>
> Thanks.
>
> Bill
>