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

Reply via email to