Archives of the TeradataForum
Message Posted: Fri, 06 Aug 2004 @ 19:30:56 GMT
Subj: | | Re: Problem with Union |
|
From: | | Dieter Noeth |
Anomy Anom wrote:
| The table structure is like this | |
I can't help you with your original problem, which really looks like a bug (according to your description). But i'd be very interested
*why* you run that query.
If there's one row:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
you want additional 15 rows like that?
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 1
3 4 5 6 7 8 9 10 11 12 13 14 15 16 1 2
4 5 6 7 8 9 10 11 12 13 14 15 16 1 2 3
5 6 7 8 9 10 11 12 13 14 15 16 1 2 3 4
...
What are you trying to achieve?
Dieter
|