On 9/12/06,
Allan Kamau <
kamauallan@yahoo.com> wrote:
create table tableA(
s_l_p_p_v_i text not null,
field1 text not null,
field2 text not null,
primary key(field1,field2));
s_l_p_p_v_i field1 field1
abc 2 1
xyz 2 4
klm 2 3
Your initial query:
select field2||'_'||field1 from tableA;
works perfectly for me:
?column?
4_2
1_2
3_2
Are you sure you are not getting the correct results?
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com http://codeelixir.com==================================================================