Archives of the TeradataForum

Message Posted: Sat, 26 Jan 2008 @ 11:19:14 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

this works as defined in SQL. ( There is no order defined "a priori" if you work with sets )

If the problem is the additional single line "order by MonthID", then there are 3 options:

1.) just add it

2.) if option 1 is not possible: Switch to a more "flexible" front end tool

3.) Join one of the standardisation committees and place your idea of "ordered views". Good Luck!

BR

Christian

	<Prev	Next>		<<First	<Prev	Next>	Last>>