Home » Archived » BIRT » simple data collecting question
| simple data collecting question [message #249707] |
Wed, 25 July 2007 05:41  |
Eclipse User |
|
|
|
Originally posted by: marcin.kierdelewicz.sitelynx.com
Hi,
I have 3 tables in my sql database. All of them have the same structure:
table1 (structure: date, integer, text) stores data:
2007-07-01, 1001, aaa
2007-07-02, 1002, bbb
2007-07-03, 1003, ccc
table2 (structure: date, integer, text) stores data:
2007-07-04, 1004, ddd
2007-07-05, 1005, eee
2007-07-06, 1006, fff
table3 (structure: date, integer, text) stores data:
2007-07-07, 1007, ggg
2007-07-08, 1008, hhh
2007-07-09, 1009, iii
I would like to create 1 dataset that will keep all these data together
like this:
Dataset (structure: date, integer, text) stores data:
2007-07-01, 1001, aaa
2007-07-02, 1002, bbb
2007-07-03, 1003, ccc
2007-07-04, 1004, ddd
2007-07-05, 1005, eee
2007-07-06, 1006, fff
2007-07-07, 1007, ggg
2007-07-08, 1008, hhh
2007-07-09, 1009, iii
I am sure that this is simple to do. Could you help me, please?
Thank you
|
|
|
| Re: simple data collecting question [message #249782 is a reply to message #249707] |
Wed, 25 July 2007 12:25  |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Marcin,
Can you not use a UNION statement in your query?
Jason
Marcin Kierdelewicz wrote:
> Hi,
> I have 3 tables in my sql database. All of them have the same structure:
>
> table1 (structure: date, integer, text) stores data:
> 2007-07-01, 1001, aaa
> 2007-07-02, 1002, bbb
> 2007-07-03, 1003, ccc
>
> table2 (structure: date, integer, text) stores data:
> 2007-07-04, 1004, ddd
> 2007-07-05, 1005, eee
> 2007-07-06, 1006, fff
>
> table3 (structure: date, integer, text) stores data:
> 2007-07-07, 1007, ggg
> 2007-07-08, 1008, hhh
> 2007-07-09, 1009, iii
>
> I would like to create 1 dataset that will keep all these data together
> like this:
> Dataset (structure: date, integer, text) stores data:
> 2007-07-01, 1001, aaa
> 2007-07-02, 1002, bbb
> 2007-07-03, 1003, ccc
> 2007-07-04, 1004, ddd
> 2007-07-05, 1005, eee
> 2007-07-06, 1006, fff
> 2007-07-07, 1007, ggg
> 2007-07-08, 1008, hhh
> 2007-07-09, 1009, iii
>
> I am sure that this is simple to do. Could you help me, please?
> Thank you
|
|
|
| Re: simple data collecting question [message #250037 is a reply to message #249782] |
Thu, 26 July 2007 11:27 |
| Eclipse User |
|
|
|
Originally posted by: marcin.kierdelewicz.sitelynx.com
Dear Jason,
I am sorry for such level of questions. I feel shame.
Thank you for your help.
Best regards
Marcin Kierdelewicz
Jason Weathersby wrote:
> Marcin,
>
> Can you not use a UNION statement in your query?
>
> Jason
>
> Marcin Kierdelewicz wrote:
>> Hi,
>> I have 3 tables in my sql database. All of them have the same structure:
>>
>> table1 (structure: date, integer, text) stores data:
>> 2007-07-01, 1001, aaa
>> 2007-07-02, 1002, bbb
>> 2007-07-03, 1003, ccc
>>
>> table2 (structure: date, integer, text) stores data:
>> 2007-07-04, 1004, ddd
>> 2007-07-05, 1005, eee
>> 2007-07-06, 1006, fff
>>
>> table3 (structure: date, integer, text) stores data:
>> 2007-07-07, 1007, ggg
>> 2007-07-08, 1008, hhh
>> 2007-07-09, 1009, iii
>>
>> I would like to create 1 dataset that will keep all these data
>> together like this:
>> Dataset (structure: date, integer, text) stores data:
>> 2007-07-01, 1001, aaa
>> 2007-07-02, 1002, bbb
>> 2007-07-03, 1003, ccc
>> 2007-07-04, 1004, ddd
>> 2007-07-05, 1005, eee
>> 2007-07-06, 1006, fff
>> 2007-07-07, 1007, ggg
>> 2007-07-08, 1008, hhh
>> 2007-07-09, 1009, iii
>>
>> I am sure that this is simple to do. Could you help me, please?
>> Thank you
|
|
|
Goto Forum:
Current Time: Wed May 07 00:53:47 EDT 2025
Powered by FUDForum. Page generated in 0.02494 seconds |
Home