On Tue, 28 Oct 2003 [EMAIL PROTECTED] wrote: > > In trying to trim some data while selecting and loading from 2 tables > into 1 I get the following: > > SELECT TRIM(TRAILING ' ' FROM s.strk_sym_cmplt), TRIM(TRAILING ' ' FROM > s.stk_sym), s.c_p, o.dta_date, o.dta_date_num, o.dta_date_dys, o.strk_sym, > o.strk_yr, s.strk_num, s.exp_sym, s.exp_mo, s.exp_mo_num, s.exp_yr, > s.exp_yr_num, s.exp_date, s.exp_date_dys, o.opn, o.hi, o.lw, o.cls, o.vol, > o.opn_intrst, o.bd, o.ak > INTO TABLE optn_calls_tbl > FROM option_data_oprtnl o, strk_data_oprtnl s > WHERE TRIM(TRAILING ' ' FROM o.strk_sym_ful) = TRIM(TRAILING ' ' FROM > s.strk_sym_cmplt) AND s.c_p = 'C'; > ERROR: Attribute 'rtrim' is repeated > > I understand that rtrim is an underlying function to trim. Is this a BUG??? > How do I fix this problem?
You probably want to give your columns names, SELECT TRIM(...) AS strk_sym_cmplt, TRIM(...) AS stk_sym, ... ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
