Database Programming, Help!

ren
#1 / 6

Help!

A table(t1) has two fields(f1,f2).
How can I get a recordset that has a single field that include both f1 and
f2 in a single SQL ?

Sun, 18 Apr 2004 13:03:07 GMT

Harinatha Reddy Gorl
#2 / 6

Help!

HI
U can join like this:

select f1 + '--' + f2 as Myfield from t1

Instead of '--', you can use any delimiter.

Best of luck

Harinatha Reddy Gorla
Software Engineer
Smart Software Technologies,
Hyderabad, India

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Sun, 18 Apr 2004 18:16:13 GMT

ren
#3 / 6

Help!

Thanks!
But maybe you had misunderstand me.
I want get a recordset that include f1 andf2.
It means that:
f1 include:
aaa
bbb
ccc
-----------------
f2 include
ddd
fff
ggg
I want get recordset that include:
aaa
bbb
ccc
ddd
fff
ggg
not
aaaddd
bbbfff
cccggg
or other.

Can you help me?

Quote:

> HI
> U can join like this:

> select f1 + '--' + f2 as Myfield from t1

> Instead of '--', you can use any delimiter.

> Best of luck

> Harinatha Reddy Gorla
> Software Engineer
> Smart Software Technologies,
> Hyderabad, India

> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Mon, 19 Apr 2004 16:41:08 GMT

oj
#4 / 6

Help!

ren,

select f1 from tb
union all
select f2 from tb

-oj

Quote:

> Thanks!
> But maybe you had misunderstand me.
> I want get a recordset that include f1 andf2.
> It means that:
> f1 include:
> aaa
> bbb
> ccc
> -----------------
> f2 include
> ddd
> fff
> ggg
> I want get recordset that include:
> aaa
> bbb
> ccc
> ddd
> fff
> ggg
> not
> aaaddd
> bbbfff
> cccggg
> or other.

> Can you help me?

> > HI
> > U can join like this:

> > select f1 + '--' + f2 as Myfield from t1

> > Instead of '--', you can use any delimiter.

> > Best of luck

> > Harinatha Reddy Gorla
> > Software Engineer
> > Smart Software Technologies,
> > Hyderabad, India

> > *** Sent via Developersdex http://www.developersdex.com ***
> > Don't just participate in USENET...get rewarded for it!

Mon, 19 Apr 2004 16:50:00 GMT

Harinatha Reddy Gorl
#5 / 6

Help!

HI
Try this:

(select A.f1 as MyField from tbltest A)
union all
(select B.f2 from tbltest B)

Harinatha Reddy Gorla
Software Engineer
Smart Software Technologies,
Hyderabad, India

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Mon, 19 Apr 2004 17:03:53 GMT

ren
#6 / 6

Help!

Another question.
There is two table ,each has two fields:name char(8),data long

I want to get a recordset that has the name and sum(data).
f1 include:
aaa 10
bbb 11
ccc 12
-----------------
f2 include
aaa 13
fff 14
bbb 15
the recordset is:
aaa 23 '10+13
bbb 26 '11+15
ccc 12 '12
fff 14 '14
How can I get it???

Quote:

> HI
> Try this:

> (select A.f1 as MyField from tbltest A)
> union all
> (select B.f2 from tbltest B)

> Harinatha Reddy Gorla
> Software Engineer
> Smart Software Technologies,
> Hyderabad, India

> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Fri, 23 Apr 2004 17:31:04 GMT