On 9/12/06, Allan Kamau <[EMAIL PROTECTED]> 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 field1abc 2 1xyz 2 4klm 2 3
Your initial query: select field2||'_'||field1
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
--- Aaron Bono <[EMAIL PROTECTED]> wrote:
> On 9/12/06, Allan Kamau <[EMAIL PROTECT
On 9/12/06, Allan Kamau <[EMAIL PROTECTED]> wrote:
Hi all,This is a plain simple sql question appologies forposting it here.Am looking for a way of combining values from severalfields(and introducting value separators).select field2+"_"+field1 from tableA;
I've triedselect field2||'_'||field1 from
Hi all,
This is a plain simple sql question appologies for
posting it here.
Am looking for a way of combining values from several
fields(and introducting value separators).
select field2+"_"+field1 from tableA;
I've tried
select field2||'_'||field1 from tableA;
I get "1" as the result(which is
