Help! 
Author Message
 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
 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
 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
 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
 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
 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
 
 [ 6 post ] 

 Relevant Pages 

1. help,help,help,help,help,help,help,help,help,help,help,help,help,

2. Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,

3. help help help help help help help help help

4. SQL To ORACLE Help Help Help Help Help

5. query:HELP! HELP HELP HELP HELP

6. Help help help help

7. HELP HELP HELP HELP!

8. HELP HELP HELP HELP

9. HELP HELP HELP

10. Refresh Test Environment help help help

11. backup HELP HELP HELP

12. HELP HELP HELP!!!!


 
Powered by phpBB® Forum Software